Assuming length is required, the following 38 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
- 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
-
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: *
-
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: *
-
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
- 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
-
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
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
"/_+$/", "") 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
- Language: *
-
Forum Ruleshttps://joellipman.com/static-items/forum-rules.html
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: *
-
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: *
-
Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html
%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: *
-
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: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF