Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') OR `fulltext` LIKE CONCAT('%',@stringtoFind,'%') You might get some errors talking about some empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and...

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

Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 Importing Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise you might overwrite your LIVE/production database). Click on the Data Import/Restore link in the left panel.

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 the varchar value 'B110' to data type int. I'm not using any of the non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 button. When that's done, Right-click on the new phone and select "Restore from Backup..." Select the backup you just made (might default to a different backup so click on the dropdown to make sure it's the one you just made). Enter the password you...

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

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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 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 the database level can save some time. Why? I have an Excel report...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment....

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 of DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep our XSLT with some slight modifications. First let's look at the...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 of the area I was going to film or fly. I wanted it to display the flight restrictions of the area and any other hazards I might need to take into account. Other apps I found only covered the USA, this one I wrote covers the world and can be added to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 Comments/Questions Please use the comment box below to add any questions (you can even post anonymously) or suggestions you might have. Thank you for your time! « DOWNLOAD ݏ

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 I'm going to demo two methods here using the Setup the Connection Link Login to ZohoCRM as the creator super admin/owner (might not be the same as CRM super admin!!!) Go to Setup » Developer Space » Connections » Create Connection » Zoho Ensure you...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 a quote and applied a template to it: The Solution After removing all styling, taking away classes and ID fields that might have been reserved for Zoho rendering (which did nothing to fix this problem), I found the cause of all the pain. I was setting a...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 VIEW ON *.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Suggestions? I'm all up for any suggestions people might have on how this can be improved but it's the one I'm going on for the moment which works fine.

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

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

06 May 2019 '_', url_counter); set url_counter = url_counter + 1; end while; END; | DELIMITER ; Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can run it anyway. Additional Note(s): The trigger only runs if...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to find the solution with the...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 do the same thing but it's a fixed width/height and question of preference. There are cases however when the openUrl method might be better, for example, for confirmation dialogs (embedded form). Source(s): Zoho Creator v4 - Functionality based URLs -...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 control panel, go through the process until this part is complete. Find the DNS Manager in your control panel, it might be called something like "Advanced DNS Editor", "Advanced Zone Editor" or "DNS Zone Editor": If the subdomain has a CNAME record,...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 task... because it is possible, the technique above is simply wrong. The trick and solution is a lot simpler than you might think... Doing the above, I would get a really messy response (I'm targeting an API made with ExpressionEngine) such as: Fatal...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module to another, sometimes you need to manage existing multi-lookups/users...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 on a laptop and can apply a function lock (fn) and the numbers on the right of your keyboard are enabled. Which numbers you might ask? Well every character is built of a collection of digits that are to be entered in their specific order. Search for...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *