Assuming length is required, the following 41 results were found.
-
pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) - LENGTH(REPLACE(LOWER(TRIM(a.title)), '.$sql_keyword.',\'\'))) / LENGTH('.$sql_keyword.'))) +...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
IS NULL ORDER BY t2.COLUMN_NAME Method #3 And a further enhancement which lists the different datatypes, is_nullable, maxlength and collations side-by-side: -- all columns side by side SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
ValueToConvert.IndexOf(myValue)) + myValue; McValue += ValueToConvert.Substring((ValueToConvert.IndexOf(myValue) + myValue.Length), 1).ToUpper(); McValue += ValueToConvert.Substring((ValueToConvert.IndexOf(myValue) + myValue.Length) + 1); ValueToConvert...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
record to an opportunity (or Deal) record. If you are using custom fields, then just ensure that the data type and field lengths match. In this case, they are system fields for the Postal Code which out-of-the-box differ in length so they do not list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
string1 + string2 SS v2012+: CONCAT(string1, string2 [, stringN ]) String Substring SUBSTRING( string,start,length ) SUBSTRING( string,start,length ) String Length LENGTH(string) BIT_LENGTH(string) CHAR_LENGTH(string) LEN(string) DATALENGTH(string)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
remove terms that are in the omit word database if ((!in_array($term, $omit_search_words))&&(strlen($term)>=$MinimimumStringLength)) { $omitted_words_array[]=$term; $out[]=$term; } } $terms=array(); $terms=$out; # start creating the sql query $terms_db...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len INT; -- string length,self explanatory DECLARE out_str text DEFAULT ''; -- return string holder DECLARE temp_str text DEFAULT ''; -- temporary...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
ChatGPT")) { // // store user input to a CRM record m_Create = Map(); v_Title = if(v_UserMessage.length()>40, v_UserMessage.subString(0,40) + "...", v_UserMessage); m_Create.put("Title", v_Title); m_Create.put("Content", v_UserMessage.trim());...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
ADD ' + STUFF( ( -- Code to concatenate column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE ',' + COLUMN_NAME + ' ' + DATA_TYPE + '(' + CAST(CHARACTER_MAXIMUM_LENGTH...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
extension into an MVC model (fixes H3 and Module Class Suffix issues) - Removed Joomla! Admin Option: Content Database Length - Date Uploaded: Mon, 13th Jun 2011 1.6.3 - Core script reverted to v1.5.2 - Styled Joomla! Admin Options into sliding panels....
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
with the line numbers prefixed and open it; the 1000 is the number of lines but you can increase/decrease this to the length of the files you usually do this to (put a higher number than the maximum length [=number of lines] of the files you will be...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
to exclude any rows we don't want based on criteria l_NewSubformRows = new Array(); for (i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"/_+$/", "") return v_Ugly } fn_MD5(string, case := False) ; by SKAN | rewritten by jNizM { o:="" static MD5_DIGEST_LENGTH := 16 hModule := DllCall("LoadLibrary", "Str", "advapi32.dll", "Ptr") , VarSetCapacity(MD5_CTX, 104, 0),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
sales order ID var v_FirstSalesOrderID = null; // loop through related sales orders for (var i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
database level checks for alphanumeric values: -- ORACLE -- 0 if is alphanumeric, 1 or more if not alpha numeric. SELECT (LENGTH(TRIM(TRANSLATE(:ParameterToCheck, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ' ')))) AS...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
than one rule, the punishments will stack up to a maximum of 2 months, or a permanent ban if neccessary. If a sentencing length is 10 days or less, it is a mute, otherwise, it can either be a temporary or permanent ban.
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- 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 Deluge
- Language: *