Assuming contains is required, the following 61 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
- 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
- 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
- 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
-
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
- Language: *
-
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: *
-
@ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html
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: *
-
@ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
for the red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the page would end on a dataset row and continue the next page with the rest of the dataset....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
and after setting up all the pre-requisites in SITS first: What changes will trigger the event? Find the screen you know contains the field to monitor, in this example, it will be the Application Clearance and Decision Entry (ACD) screen. Put the cursor...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
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
- 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
-
= 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
- 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
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF