Search - Joel Lipman .Com

1. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... 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 update: /* ******************************************************************************* Function ...; Created on 22 April 2024
2. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
3. A for loop within a for loop in MS-DOS: / MS-DOS /; ... it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to use. Explaining MS-DOS batch programs is a lot easier and colleagues ...; Created on 03 October 2013
4. DataScramble - Randomizing data rows: / Transact-SQL /; What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts ...; Created on 07 December 2012
5. Search a database with SOUNDEX: / Databases /; ... easily recognized from the results ** ** ** ** Only finds the first table_name.column_name ...; Created on 11 October 2012
6. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... 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 ...; Created on 28 June 2011
7. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... &rc:BookMarkID=1 Provide search criteria and find the first instance http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:FindString=foo Note: ...; Created on 11 February 2011
8. MySQL Commands to display all columns: / MySQL /; ... The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that had the data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value ...; Created on 28 October 2010
9. Keyboard and mouse shortcuts in Google Chrome: / Google /; ... 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, ...; Created on 23 September 2009