Assuming insert is required, the following 53 results were found.
-
databases, reading from the old Joomla database and writing to the new one. To run this script, your user needs SELECT, INSERT and UPDATE privileges on the new database (only SELECT on the old database will do). Special care has been made to avoid the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
We want to maintain the same IDs for articles in case SEO settings will be enabled and the ID is in the URL. We will insert assets as new ones but associate these to the v25 assets. Categories will be associated by comparing both databases' content...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Leave has been rejected due to too many employees booking the same dates off."; c_Response = Collection(); c_Response.insert("EmployeeID":v_OutputMessage); c_Error = Collection(); c_Error.insert("errors":c_Response); return c_Error; Displays to the user...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= v_EventType; r_RowTu.Start_Time = v_EventStart; r_RowTu.End_Time = v_EventEnd; r_RowTu.In_Effect = true; c_Tuesday.insert(r_RowTu); // // create Wednesdays subform entries r_RowWe = Shifts.Wednesdays(); r_RowWe.Event_Type = v_EventType;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
expression found COLLECTION expression How? Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to what the documentation that says "This task can be used in the following events", effective...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
-- _jcomments -- -------------------------------------------------------------------------------- INSERT INTO mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03 I'm trying to insert a record for a new product if it doesn't exist in the table but if it does exist then to simply skip adding the product....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
through the Joomla installation wizard. Data Migration using SQL files: Import Categories: export SQL file and amend the insert(s) into the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50)...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
mysql_num_rows(): 80 is not a valid MySQL result resource in libraries\joomla\database\database\mysql.php on line 344 INSERT using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------ ----------------------------------------------------------------- INSERT INTO my_wordpress_db.wp_posts SELECT id 'ID', 1 'post_author', created 'post_date', created 'post_date_gmt', CONCAT(introtext, ' ',...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
most datasets will return the rows as... rows. My pic above shows my 4 reports results side by side. To do this, I had to insert a Matrix rather than a Tablix: Insert a "Matrix" into the body of your report. Drag "ReportName" into the field that says...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
,Execstatus BIT ) DECLARE @sql VARCHAR(MAX) DECLARE @tmpTblname sysname IF LTRIM(RTRIM(@Tablenames)) IN ('' ,'%') BEGIN INSERT INTO @CheckTableNames SELECT Name FROM sys.tables END ELSE BEGIN SELECT @sql = 'SELECT ''' + REPLACE(@Tablenames,',',''' UNION...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
"close": "18:00" }, "Friday": { "open": "7:00", "close": "18:00" }, "Saturday": { "open": "09:00", "close": "15:00" } } Inserting as a subform on the employee record So now we just need to append the following code which loops through the map /...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
not even computer literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to insert separator rows so ideally we would like: Day ---------------- Monday Monday Monday Tuesday Tuesday Wednesday Thursday...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
CURSOR CREATE TABLE #Scramble ( ID INT identity(1,1), ScrambledID INT, Data VARCHAR(MAX), Chosen BIT ) -- To dynamically insert the source Data into the temp table IF @WhereClause IS NULL SET @WhereClause = ' 1 = 1' SET @SqlStatement = ' INSERT INTO...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
', @StringInput), 0), LEN(@StringInput)) + 1, LEN(@StringInput)) SET @StringInput = RTRIM(LTRIM(@StringInput)) INSERT INTO @OutputTable ( StringValue ) VALUES ( @StringValue ) END RETURN END Now we want to modify this slightly so that it converts a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be done all in one go. How? Here's a use case example which you will need to adapt to your own but It...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is in the case that you have only one optical drive which is a minimum of a CD Writer and you want to make a copy of a CD. Insert original CD in the drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER Right-click...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
with the background being transparent. I want the first column to display an image based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Source(s): Zoho Deluge: invokeAPI Task Zoho CRM: Insert or Update Records (Upsert) - not used in above example but here if I want to use it one day. Zoho CRM: Update Subform Data...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF