Assuming length is required, the following 41 results were found.
-
v_includeInPicklist = false; for each index timeSlot in hourList { timeSlotStr = timeSlot.toString(); if(timeSlotStr.length() zoho.currenttime && v_CheckTime1b >= v_OpeningTime.toTime() && v_CheckTime1b...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
gpt-3.5-turbo (optimized for chat at 1/10th the cost of text-davinci-003) gpt-4 gpt-4-32k (up to 4x the context length) Source(s): OpenAI - Documentation - API Reference - Making Requests OpenAI Account - API keys OpenAI Documentation - Create chat...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
= ifnull(m_User.get("signature"),""); // // criteria, only update signatures which aren't done? //if(v_CurrentSignature.length()...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
if (v_InvoiceType == "Final Balance") { // now loop through the quoted items / line items for (i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_CrmProductCodeSafe = zoho.encryption.urlEncode(v_CrmProductCode); v_CrmProductName = if(v_CrmProductName.length() >= 200,v_CrmProductName.subString(0,199),v_CrmProductName); v_CrmProductNameSafe = zoho.encryption.urlEncode(v_CrmProductName);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the product is referred to in Xero (eg. if no code or name, then use description) v_CrmProductName = if(v_CrmProductName.length() >= 200,v_CrmProductName.subString(0,199),v_CrmProductName); v_CrmProductNameSafe =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
%V week of the year 01–53 Month %m mm month 07 %h Mon Jul %b Mon, locale's abbreviated Jul %B locale's full month, variable length July Year %y yy two digit year 00–99 %Y ccyy year 2011 %g 2-digit year corresponding to the %V week number %G 4-digit year...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
way I've seen that has worked in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of greater than 1: Almost! A problem not covered by many sites was happening to me when I had blank rows in a flat file,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
option is available from Connector/NET version 5.1.4. Specifying connection attempt timeout Use this one to specify the length in seconds to wait for a server connection before terminating the attempt and receive an error....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
'nvarchar', 'text', 'ntext') ** ** AND TABLE_SCHEMA='dbo' ** ** ** ** - For performance, return results based on string length which is 1 greater or lesser than the original ** ** string value: ** ** Automatic: ** ** @minStringLength and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = DATALENGTH(@OrigVal); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal = ''; -- 1900-01-01 SET @TimeVal = ''; -- 00:00:00.000...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
AS varchar(10)) + ' ' + CAST(@TimeVal AS varchar(16)); ELSE SET @NewVal = ''; -- REDUCE THIS STRING TO THE SAME LENGTH AS SUBMITTED VALUE // not necessary for update -- SET @NewVal = SUBSTRING(LTRIM(RTRIM(CAST(@NewVal AS VARCHAR(30)))), 1,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie "String4". So I need to delimit based on the dot/period (.) and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I have...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
(background image filling the page with a logo floating at the centre) and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
to do really: Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true"....
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
Hit Counter: no, alongside, popup, both - Parameter: Specify Group(s) which can refresh thumbnails - Parameter: Description Length - Parameter: Image Rounded Corners (latest browsers only) - Parameter: Image Border Color - Parameter: Image Border Color...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
t.fn.bcSwipe=function(e){ var n={threshold:50}; return e&&t.extend(n,e),this.each( function(){ function e(t){ 1==t.touches.length&&(u=t.touches[0].pageX,c=!0,this.addEventListener("touchmove",o,!1)) } function o(e){ if(c){ var...
- Type: Article
- Author: Joel Lipman
- Category: Bootstrap
- Language: *