Assuming string is required, the following 148 results were found.
-
s WHERE WEEKDAY(s.DateTimeCreated)=0 AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Monday', ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
",", $term); $out[] = $term; } return $out; } # prepare for MySQL regular expressions function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms into list of regular expressions # eg....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. Each string should be in a separate line in the files. When any of the strings match any part of the absolute path of the...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
Creator ID of the record. dataMap is the map() to post. connectionLinkName is the connection link obtained previously (as a string). For example: v_RecordID = "1234567890123456789".toLong(); m_Params = Map(); m_Params.put("FieldToUpdate",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
l_Params.add("access_type=" + v_Access); l_Params.add("prompt=" + v_Prompt); v_Url = v_EndPoint + "?" + l_Params.toString("&"); info v_Url; openUrl( v_Url , "new window"); This will open a page for you with a Zoho Consent form where you confirm whether...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
2, 3"]} // What Creator understands: FAILS {"My_MultiPicklist":["["Option1","Options 2, 3"]"]} With workaround .toString() // What Creator understands: FAILS {"My_MultiPicklist":["Option1","Options 2"," 3"]} How? So the way to push this value over to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // set endpoint to retrieve 5 products v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?limit=5"; // // curl (zoho invoke) request r_GetProduct = invokeurl [ url :v_Endpoint type :GET...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Component > and select the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string. Create a connection from Zoho Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
Data" The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save" click on "Done" Now click on "Edit Function" under...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) Purpose: Queries DHL for tracking information about a shipment and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
that generates an access token of the Trading API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates item/contact/sales order/package...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
Consider the following code: /* ******************************************************************************* Function: string standalone.fn_Deal_UpdateRelatedToCancelled() Label: Fn - Customer Deals - Cancel Related Records Trigger: Standalone...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to preview what records it will delete. I also recommend doing a data backup beforehand. Adapt the below as needed: string standalone.fn_Products_RemoveDuplicates() { /* *******************************************************************************...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
be associated with an email address. If not, then see the 2nd snippet of code. SELECT concat('REF-', left_pad(to_integer(substring(r2."ID", 8)), 6, '0')) AS "Attempt ID", s."Title" AS "Survey", r2."End Date" AS "Response Date", CASE p."Title" WHEN...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
back onto a single line. How? Below are three examples demonstrating multi-line assignments in Zoho Deluge. 1) Multi-line string concatenation, converted into a map This builds a JSON string over several lines, then converts it into a map so values can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
assets: -- - Import banner categories from J15 and insert as assets in J30 SET @new_jos_assets_last_inc=( SELECT (SUBSTRING_INDEX(`name`, '.', -1)*1) AS lastcatid FROM `my_new_database`.my_prefix_assets WHERE `name` LIKE '%.category.%' ORDER BY...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
{ $query='SELECT COUNT(*) as ArticleCount FROM `'.$db_prefix.'content` WHERE id='.mysqli_real_escape_string($db_connect, $_GET['id']); if ($result = mysqli_query($db_connect, $query, MYSQLI_USE_RESULT)) { while($obj = $result->fetch_object()){...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
-- $rows['0']['username'] -- foreach( $rows as $row ) { -- $this_user = $row['username']; -- $user_list_string.= " $this_user "; -- } loadObjectList $query="SELECT username FROM users WHERE name='me'"; $db->setQuery($query); $rows =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB