Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 What? A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 '.curl_error($ch2); } else{ $output = $response; } // close second request handler curl_close($ch2); } return $output; } Usage: $mime_type = 'video/mp4'; // could be 'image/jpeg', etc. $new_name = 'My Video'; $the_file_and_path =...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We...

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

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 users to distinguish between official Joel Lipman .Com website administrators and other registered members. WEBSITE USAGE Welcome to our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 SC_Name[A_Index] := A_LoopFileName SC_TotalFiles := A_Index } } -- put this function at the end of the script. -- usage: SC_Load("C:\*.*", 1) MsgBox, TotalFiles %SC_TotalFiles% -- yields number of files in a directory recursively. Method #4:...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 string errorMsg1 = "Invalid datatype for {0}. Inputs must be DT_STR or DT_WSTR"; string errorMsg2 = "Invalid usage type for {0}. Inputs must be READWRITE"; // Check whether each column type is DT_STR/DT_WSTR for (int x = 0; x...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 the message we want to send v_Message = "This is a test text"; // // build up the endpoint (see https://www.twilio.com/docs/usage/requests-to-twilio#http-methods for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token +...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 API (eg. website checkouts) then set these. Mine don't as the Creator app I'm making is for staff only. REST Admin API: Usage: Here's a quick test I do retrieving 5 products using the REST admin API: // // app specific r_ShopifyAPI =...

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

Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 { "payment_terms_id": "", "is_mandatory": true, "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please refer to the Zoho...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 have to go through a few hundred files manually checking that I have the converted version and deleting the original. SAMPLE USAGE: If you have a portable media player that needs to convert media files before they can be transferred to the device, then...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 -- 1 if is alphanumeric, 0 if not alpha numeric. SELECT @ParameterToCheck REGEXP '^[A-Za-z0-9]+$' AS AlphaNumeric FROM... Usage -- Using the ORACLE example SELECT Column1, Column2, (LENGTH( TRIM( TRANSLATE( :ParameterToCheck,...

• 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 ALTER TABLE #myScrambledTable DROP COLUMN dummyIndex; -- Show me the results SELECT * FROM #myScrambledTable; END GO -- Usage: -- EXECUTE dbo.usp_MakeTableTemp 'mySchema.myTable'; Post-Notes Added a dummy index to track row numbers. Copies structure...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 THEN RETURN ('Error in submitted value'); WHEN others THEN RETURN ('Unable to generate random value'); END UFN_DATASCRAMBLE; Usage SELECT -- UFN_DATASCRAMBLE(DATE_CREATED, 'DATE') scramble_column, -- testing inputted column...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check...

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

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 PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all...

• 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 v1.2 ** ** Description: Script to create a SQL query which searches a database with SOUNDEX (detects typos). ** ** ** ** Usage: ** ** Step #1: EXEC [usp_GenerateSearchbySoundexQuery] 'mySearchString', 'tableSchemaToSearch'; ** ** Step #2: Run the query...

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

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 ** ** Description: Stored Procedure to list distinct values and counts (defaults to case and accent-sensitive). ** ** ** ** Usage: ** ** EXEC [usp_ListDistinctValuesAndCounts] 'myDB.dbo.myTable', 'myColumn1,myColumn2', 'Latin1_General_CS_AS'; ** ** **...

• 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 to the END (exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC [usp_CountRecordsPerTablePerColumn] '3', 'Customer_ID'; ** ** ** ** Parameters : ** ** - Value: the value you want...

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA', 'ColumnNameA'; ** ** ** ** EXEC usp_ScrambleMultivalue...

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