Assuming exists is required, the following 66 results were found.
-
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
-
(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: *
-
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
-
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: *
-
are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
your temporary directory instead of using the root c drive. If you do not have c:\windows folder than find where "cmd.exe" exists and chage the path in the above instructions accordingly. The use of some environment variables (eg. %ComSpec% or %windir%)...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
Something has happened to my images folder, does it matter? Answer: No, the program checks if a folder called "screenshots" exists in the folder this program is run from. If it doesn't see one, it tries to create one. I personally empty that folder...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
your ORIGINAL site (live/production) Add the weblink on your ORIGINAL site. (you wont need the service as the image already exists...) Don't have a COPY of your Joomla site? (submitted by Webmaster de EDiSoPortal) Create a category for your weblinks...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Add a comma and the two letter country code (preferably "iso-3166-1 alpha-2") to the name if the location of the same name exists in multiple countries of the world. Zones (circles on map): Static Zones are created based on a listed airport, airfield,...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
{ if(!l_ExcludeFields.contains(v_FieldName)) {... do stuff here... } } // notes: // no need to check if element exists on "removeElement" Zoho OAuth Connector Just in case you don't know how to setup a Zoho OAuth Connector, here's how you do it in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) { if(!isnull(r_CreatorFile.File_Download)) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Line_Items=c_LineItems ]; From the documentation Additional Note that any bidirectional relation field that exists will be prepopulated using the method above. Clear subform of all its rows: input..clear(); Changing the picklist/dropdown options in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Code Consider the following standalone function which loops through every contact and deletes the duplicate lead (if a lead exists with the same email as a contact): // init v_Count = 0; v_CountDeleted = 0; // // sort criteria for our selection...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the below is how I achieved this. How? First-off, let me list the various formats that Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form called Portal_Listing with a report/view called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
if in system already (update or create) if(!isnull(r_ThisContact.get("ContactID"))) { // check if already Xero Ref ID exists in CRM Contacts v_CrmContactID = 0; l_SearchResultsByRef = zoho.crm.searchRecords("Contacts","Xero_Ref_ID:equals:" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
SFTP - SSH File Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: Schedule with Timezone specified (click...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Error(s) Encountered Could not find a matching parent record for this lookup field. - Parent Id: Ensure that CRM Record ID exists and that you are uploading the associated module CSV at the same time as the attachments (eg. if Parent Id is a CRM contact...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM and at least 1 line item is mandatory l_CrmProductLineItems =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Uses row.ID as the identifier to prevent duplicates. c_CheckDoc = Document[Subform_Row_ID == v_ImageRowID]; // // if exists then update if(c_CheckDoc.count() > 0) { c_CheckDoc.Image=c_ImageRow.Image; c_CheckDoc.File_field=f_DownloadFile; v_UploadFileID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *