Assuming contains is required, the following 65 results were found.
-
child node containing string "SURNAME" SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM Event_XML.nodes('/*/*[contains(local-name(.),"SURNAME")][1]') AS r(c) -- added [1] to only get 1 result returned ) AS Node_Surname FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
", " Le ", " La ", " Of ", " Or ", " To ", " Van " }; foreach (string myValue in exceptionArray_this) { if (ValueToConvert.Contains(myValue)) { ValueToConvert = ValueToConvert.Replace(myValue, myValue.ToLower()); } } // tranformation exceptions: words...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making some minor changes to the MediaWiki LocalSettings.php...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
on other records. Additional: Here's an AHK script I wrote that produces a GUI that takes an external file where column A contains the key/ID of the Contact in the 3rd-party database and column B contains the filename as downloaded from the 3rd-party...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
rows: SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
is not allowed to make this change m_Output.put("status","success"); if(v_LeadStatus != "") { if(l_DisallowedProfiles.contains(v_UserProfile) && l_DisallowedOptions.contains(v_LeadStatus)) { m_Output.put("message","Your user profile does not allow you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
3.5 Turbo // // initialize m_Response = Map(); l_Messages = List(); v_Message = message.trim(); // // if the message contains a question mark, send it to OpenAI if(v_Message.contains("?")) { v_Question = v_Message; // // Need to add your own OpenAI...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
to be present within the containing element complexContent Defines extensions or restrictions on a complex type that contains mixed content or elements only complexType Defines a complex type element documentation Defines text comments in a schema (must...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
code of each element by dragging the curser over the webpage. Frequently Asked Questions What is a pwb? - A variable that contains a pointer to the web browser object (Internet Explorer). Here is a simple script for creating one: Code: ; AutoHotkey_L:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
"Profile 2", etc. Scan the preferences file for JSON key "name" and extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2",...) Sort the second column (contains "Joes Personal Profile", "Joes Work Profile", etc) Create...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
considered “further restrictions” within the meaning of section 10. If the Program as you received it, or any part of it, contains a notice stating that it is governed by this License along with a term that is a further restriction, you may remove that...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];......
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= Partners_Quote[ID == r_Quote.ID];. In the example below, this is a merging process of each quote which only contains 1 line item and not a subform of line items. You could adapt the following to also loop through a subform found on each record but for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Code to Add a value to a multi-lookup (on Create Record): // sample code when creating a record in a module that contains a lookup m_Create = Map(); m_Create.put("Name","Joels Amazing Test"); r_Create = zoho.crm.createRecord("Tests", m_Create); // now...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
type :POST parameters:x_Params headers: m_Headers ]; // parse out the SessionID v_SessionID = ""; if(r_ResponseXML.contains("Success")) { // tidy up the response so we can executeXPath x_Response = r_ResponseXML.executeXPath("/*/*").toXmlList(); for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= m_Node.get("product").get("updatedAt"); v_VariantModified = m_Node.get("updatedAt"); // // transforms if(v_ProductTitle.contains(",")) { v_ProductTitle = "\"" + v_ProductTitle + "\""; } if(v_ProductHandle.contains(",")) { v_ProductHandle = "\"" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
text file to be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
public URL of a subform row other than making the subform link to an existing form and not a blank form. The document form contains the fields: Ticket (lookup to Ticket form), Image, File, Local Image, Subform Row ID (prevents duplicates). Note: I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= v_CssStyle; Code for On User Input of Color Picker: if(!isNull(input.Color_Picker) && !input.Color_Picker.contains("button")) { v_HeximalRef = input.Color_Picker.getsuffix("background-color:").getprefix(";"); input.Hexadecimal = v_HeximalRef; //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... } isBlank() can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "----------------------...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *