Assuming exists is required, the following 66 results were found.
-
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: *
-
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: *
-
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 CRM
- Language: *
-
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 Creator
- Language: *
-
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 Inventory
- Language: *
-
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
-
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
-
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 Books
- Language: *
-
-- 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: *
-
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
-
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: *
-
' + 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
-
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
-
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 CRM
- Language: *
-
so I Go to Workflows > Form Workflows > Select your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is Created or Edited (Form Event) When to trigger workflow Load of the form Name the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ v_CandidateZohoID + r_Data.get("id") + ")"; l_CheckExists = invokeurl [ url :v_SearchEndpoint type :GET connection:"my_connection" ]; v_CountExists = 0; if(!isnull(l_CheckExists.get("data"))) { for each r_Check in l_CheckExists.get("data") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
TXT record itself will depend on your mail server or the domain registrar's website to manage your DNS: If no TXT record exists for the SPF, then create a TXT record Specify the Host as @ Set the TXT Value to v=spf1 include:one.zoho.eu ~all If the TXT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
//info r_TeamFolderInfo; // // ====================== // get list of subfolders by name (creates a timestamped duplicate if exists so need to check if it exists first) //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Workdrive
- Language: *
-
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
-
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