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

23 September 2009 F5 or Ctrl+R Reloads your current page. Esc Stops the loading of your current page. Ctrl+F Opens the find bar. Ctrl+G or F3 Finds the next match for your input in the find bar. Ctrl+Shift+G, Shift+F3, or Shift+Enter Finds the previous match for your...

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

MySQL Commands to display all columnshttps://joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that had the data_type TEXT across all databases: SELECT...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 another one. Question How does the thumbnail name generating work? Answer: The program loops through the images folder and finds a name that isn't taken (something like "000065.bmp"). It won't overwrite existing pictures. If you are batch processing a...

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

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

11 October 2012 : ** ** Will pick up variations with trailing spaces but this is not easily recognized from the results ** ** ** ** Only finds the first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has two rows,...

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

DataScramble - Randomizing data rowshttps://joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 with "yes received" response. As such, here's a function which lists the Shopify webhooks it's responsible for and if it finds one missing, it is to restore it. This function only has to check on 2 webhooks: the order update and the inventory level...

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

A for loop within a for loop in MS-DOShttps://joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to use....

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