Assuming length is required, the following 38 results were found.
-
'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
-
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
-
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
-
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: *
-
Ordinals = "th,st,nd,rd".toList(); English_Ordinal = Ordinals.get(0); EO_Index = This_Day_Date.substring(This_Day_Date.length() - 1).toLong(); if((EO_Index == 1 || EO_Index == 2 || EO_Index == 3) && (This_Day_Date != "11" && This_Day_Date != "12" &&...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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
- 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: *
-
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: *
-
DF { If not FileExist( sFile:=A_LoopFileLongPath ) { Return } SplitPath, sFile, _FileExt, _Dir, _Ext, _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ; Delete parameter fex.SetCapacity(11) ; Make room for Extra info...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- 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
- 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
- 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
- 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
- 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: *
-
Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html
on Execution Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation but wouldn't it be nice if you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF