Assuming required is required, the following 52 results were found.
-
FROM @search_string; EXECUTE search_string; SET COUNTER = @CNT_VALUE; #SELECT COUNTER; IF COUNTER>0 THEN # Inserting required results from search to table INSERT INTO temp_details VALUES(db,tbl,clmn); END IF; IF done=1 THEN LEAVE table_loop; END IF; END...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
(') and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS),...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
programming language: UserFolder:="C:" -- UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib contains H,R,S...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
run over by a bus, so I am used to needing a backup plan. My aim is always to hand over the project so that I am no longer required. Isn't that when we know we did our job best? When nobody knows you did anything at all?
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
is ticked. Store/save your EOR Setting up the Table Update Process (TUP) I always think of this as the trigger but it's required for your TOTs. Run TUP from the menu system Enter the relevant dictionary and entity For table update code enter one similar...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Aviation Authority (CAA) and European Air Transport Command (EATC). These are: 400ft altitude limit Line-of-Sight (LoS) required Stay away from built-up areas Note: There are slightly different regulations for a small unmanned aerial system (less than...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
close connection curl_close($ch); Things I stumbled upon regarding SSL and cURL Posted data for third-party apps is often required via SSL so this may come in handy curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users)....
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
{ info r_UserDetails.get("id"); } List CRM Users (ActiveUsers) from Creator or other Zoho App Note the use of .toMap() required for other apps to read this JSON string response: l_Users= List(); m_UserType = Map(); m_UserType.put("type","ActiveUsers");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_BooksOrgID = organization.get("organization_id"); // // a sales order has been created, get its ID (required) and reference (optional) r_NewSoDetails = r_CreateSO.get("salesorder"); v_NewSoID = r_NewSoDetails.get("salesorder_id"); v_NewRefNum =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article with the snippet of code required to duplicate or clone a record in Zoho CRM using Zoho Deluge. Why? The aim here is to have a scheduled task that on the 1st of every month, takes the invoices for the month before, and duplicates each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Enter a Connection name (for this example I will call it "CRM API v2") Select the appropriate scope(s): ZohoCRM.coql.READ Required! ZohoCRM.modules.{module_name}.{operation_type} or ZohoCRM.modules.all Click Create and Connect You will be prompted to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5 (Plan Premium or greater is required - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual Studio Code v1.48.2 Prerequisites Download nodejs...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
]; info r_InvoiceDetails; Common Error(s): {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not found","status":"error"} is because you did this: r_CreateCrmQuote = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ l_Errors.add("- Record Name"); } if(l_Errors.size() > 0) { alert "Please enter the following required fields:\n" + l_Errors.toString("\n"); } else { //... code to submit form/save to record here } Then save the data by adding the record or updating...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
break; } } m_CreateSO.put("salesperson_id",v_SalesPersonID); } Additional Note(s): Scope(s) required: for the connection I think it was ZohoBooks.settings.READ for the sales persons and then ZohoCRM.modules.all for the CRM sales orders.
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// assigning values for various subform fields in the row . = ; . = ; // declaring another row (declare as many rows as required) = .(); // assigning values for various subform fields in the row . = ; . = ; // declare a variable to hold the collection...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
using a third-party server (my example here is a LAMP server): Complete webhook setup by passing 'Intent to receive' required stage. Xero will test both a valid and invalid signed webhook. So I'm going to cheat, by setting up a PHP script on a server we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to present the user with the days of the week which they can then click on to select a particular day. Some navigation is required in the form of a left arrow and right arrow to see previous or next weeks respectively. What I have: What I want: How?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF