Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 \_ A “_” character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES ('1', 'It''s amazing!'); Bear this...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 give radically high relevance to articles where the search term is found in the title. \plugins\search\content\content.php: Insert this between the if ($sContent && $limit > 0){ and before the from part of the query $query->from('#__content AS a'); //...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias: DROP TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Excel: Extract hyperlink from linkhttps://www.joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

06 November 2014 text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 content, then press Ctrl+C. Copies content to the clipboard. Place your cursor in a text field, then press Ctrl+V or Shift+Insert. Pastes content from the clipboard. Place your cursor in a text field, then press Ctrl+Shift+V. Paste content from the...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 moves to fill up the space... There are some suggestions on the net but they didn't work or didn't apply for me. I had to insert a rectangle that separates the textboxes (so fills up the empty space with an object)... The visibility expressions for both...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 cron directory. cat "${CRONDIR}"/* | clean_cron_lines >>"${temp}" # */ # Add each user's crontab (if it exists). Insert the user's name between the # five time fields and the command. while read user ; do crontab -l -u "${user}" 2>/dev/null |...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 your joomla database. Note that your database user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key,...

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ' FROM ' + @SchemaTableName; -- Copy given table data into temporary table INSERT INTO #myScrambledTable EXEC(@SqlToExecute); -- Drop dummy column from table declaration ALTER TABLE #myScrambledTable DROP...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 + ''', COUNT(*) AS Count FROM ' + @p_SearchTable + ' GROUP BY ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation; INSERT #ListDistinctValuesAndCounts EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @ColToProcess END CLOSE Cursor1; DEALLOCATE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 FROM ' + @TableToProcess + ' WHERE ' + @p_Column + ' = ''' + CAST(@p_Value AS VARCHAR) + ''' GROUP BY ' + @p_Column + ''; INSERT #CountRecordsPerTablePerCol EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END CLOSE Cursor1; DEALLOCATE...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; Make sure you have the INSERT INTO commands if this includes website data!!! Drop the table Reload the script you just modified.

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 ENT_COMPAT, 'ISO-8859-15', true), ENT_COMPAT, 'UTF-8'); My other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection)...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 to convert the node into a map: info m_Response.get("item").toMap().get("item_id"); // yields: 123456789012345678 Problem: Inserting a date time string into a date time field in Deluge So annoying but sometimes you want to insert a date/time value into...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 module which: creates a sales order checks the returning sales order line items cycles through the invoice line items to insert the "sales_order_item_id" field v_InvoiceID = invoice.get("invoice_id"); v_BooksOrgID = organization.get("organization_id");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *