Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 X @GenerateSQLOnly -- Provide 1 if you only want to generate the SQL statements without seraching the database. By default it is 0 and it will search. Samples : 1. To search data in a table EXEC SearchTables @Tablenames = 'T1' ,@SearchStr = '%TEST%' The...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default settings). Additional -- Take a "dd/mm/yyyy" string and convert to date (when (DT_DATE)ThisDate by itself doesn't work)...

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the double-quotes): “Hello,\n\nA request has been made to reset your %s account...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio). How? Note that the restore can be done when the new phone prompts...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 2013 2.1 Personal Edition- Fixed Bug: Order By Date - Fixed Bug: Order in descending/ascending order - Enhancement: Changed default settings (matches personal site) - IMPORTANT: Cannot use "Public" usergroup to generate images!!! - Date Uploaded: Fri,...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 the following instructions to preview your app: Open a browser and Ensure you type the preceding “https” rather than the default “http” [Optional Step] This is an added note/step if you get the following error when trying to access your app on your...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in this example, I will leave this as "void") for Arguments Specify a parameter name of your...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 l_RecordsToSend.add(m_CreateQuote); m_Data = Map(); m_Data.put("data", l_RecordsToSend); // // this is REST API so by default all triggers run. Use an empty list to stop or prevent these from triggering. m_Data.put("trigger",[]); // // send via REST API...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can be searched for with the "State" field on the Lead...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 v_FromTime = zoho.currenttime.subMinutes(v_MinutesAgo).toLong(); v_TillTime = zoho.currenttime.toLong() / 1000; // // by default gets last 100 messages (doesn't return anything if no parameters specified) v_Endpoint =...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 love to hear it). We don't have more than 100 product categories so we'll just to page 1 but specifying 100 per page as the default is only 10. // // API keys (these are made up so enter your own in these 2 lines below v_MyWordPressSiteUrl =...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 Ensure that when this has been converted to a contact it removes this task.) - Use connection as system user rather than default crm connection - Reminder cannot be set for task creation time so create task at the same time as lead and set reminders...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index (not the ID of the record) m_Params = Map();...

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

Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 Choose Menu > Main Menu from the pulldown menus. Click on the Home item's name (or whatever item happens to be your default frontpage item, can't be an article). Click on the menu Parameters - Advanced on the right. Set the Category Order to No. Order...

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

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 disk, flash drive, etc) Make sure that the \components\com_kunena\template folder is on your local disk Make a copy of the default folder inside Rename this to the name of your new template (avoid any spaces) Download the new template for the Kunena...

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

Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html

06 September 2009 … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and directory permissions 5. Remove unneeded files 6....

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

Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 in shell is 'chown -R apache:apache '. 3. Check that your PHP ini specifies a reasonable maximum file size limit. By default this is 2Mb. In my example, I added the hidden input type MAX_FILE_SIZE which is ignored by more recent browsers. If you need...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 I have uninstalled and reinstalled once just to make sure everything was OK. Basically after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted my...

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