Drop If Object Existshttps://joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL DROP PROCEDURE [Common].[usp_MyStoredProcedure]; GO --...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What I have EDIT 0_00 0_30 My File 1 00_00 00_30.txt edIT 0_00 0_31 My...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 version gets attached to their contact record... all from one click of a button: Scenario 1: Credit Application: Template exists in ZohoSign Very quickly, let's go over the implementation plan for this scenario (where you have the template in ZohoSign...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 adding the product. v_Name = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, false); if(!b_Exists) { // insert into Product table r_ProductCreate = insert into...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 be accurate (eg. £499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on system to determine whether to update or create. - Check if SalesOrder already exists on system to determine whether to...

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

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

17 September 2009 processing works so now test the actual file upload Add the following code after the above code sample in step #4: if (file_exists("" . $_FILES["uploaded_file"]["name"])) { echo "".$_FILES["uploaded_file"]["name"] . " already exists. "; } else {...

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

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

06 May 2019 bullets here but I want to block any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL database table called my_table_name: What we have: /----------|-------------------|----------------------\ | id |...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- Step 2) Remove migration notes in J30 [Optional Step] -- - Remove string "(PreviousID=" where it exists in descriptions UPDATE `my_new_database`.my_prefix_banners SET description=SUBSTR(description, 1, LOCATE('(PreviousID=', description)-1) WHERE...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 view it using a Web-Browser, the image does not display: Get report to see images hosted on an external URL Check if image exists to display alternative placeholding image. Solution #1: Image does not appear within SSRS Configure the Unattended...

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

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

08 October 2012 ' + Tablename + ' WHERE ' + substring(WHEREClause,1,len(WHEREClause)-5) DELETE FROM @SQLTbl WHERE WHEREClause IS NULL WHILE EXISTS (SELECT 1 FROM @SQLTbl WHERE ISNULL(Execstatus ,0) = 0) BEGIN SELECT TOP 1 @tmpTblname = Tablename , @sql = SQLStatement...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 we will be referring to a Joomla module called "mod_moduletoupgrade" in British English (en-GB). I don't think it actually exists in reality but you replace the name "moduletoupgrade" with whatever you're upgrading and follow the below instructions. I'm...

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

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 a creator form called "myForm" // that the ID of the record is the value of the variable "myRecordID" // that a subform exists in the form called "Attachments" // that a field exists in the subform called "myUpload" // that the API name for the CRM...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 dataset with results; the remaining datasets that need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another workaround exists where if I...

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

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

07 December 2012 will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW...

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

Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `Column2` varchar(100) COLLATE...

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

Excel: Find values in one column that are not in anotherhttps://joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 are in the old column and which ones are new... Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 345678 345678 456789 567890 597890 I want the third column to...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 return $credentials['access_token']; } // manage tokens function authenticate() { global $STORE_PATH; $credentials = (file_exists($STORE_PATH)) ? getStoredCredentials($STORE_PATH) : null; if (!(isset($_GET['code']) || isset($credentials)))...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 since the access token file was last modified: // check minutes remaining $api['jwt']['token']['minutes']=0; if(file_exists($api['jwt']['token']['file'])){ $expiry_time = filemtime($api['jwt']['token']['file']) + 3600; $diff = $expiry_time - time();...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 via an invokeURL with API v2 rather than a connector. If you use POST then this adds/creates a record and if it already exists you will get a {"code":1001,"message":"Item \"...\" already exists."}. Documentation advises that the payload is empty which...

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