Assuming 1 is required, the following 337 results were found.
-
A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
double-quotes as phrase makers. function search_transform_term($term){ $term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term); $term = preg_replace("/,/", "{COMMA}", $term); return $term; } function search_split_terms($terms){ $terms =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line Feed -- CHAR(13) = Carriage Return And in SSIS: TRIM( LOWER(...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
for me... Set the default values for your from and to date respectively: -- From Date (european format - dd/mm/yyyy) =CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now()))) -- To Date (european format - dd/mm/yyyy) =dateadd("d",-1,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
-- eg. O'Brien will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x') Microsoft T-SQL Note the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'");...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
Ingredients 100g/3½oz oats 3 tbsp honey 50g/1¾oz self-raising flour 1 free-range egg 4 tbsp dried cranberries 5 tbsp butter For the caramel sauce 50g/1¾oz butter 50g/1¾oz caster sugar 50ml/1¾fl oz double cream 1 orange, peeled and segmented Method 1....
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
- Type: Portfolio Item
- Language: *
-
to OpenAI ChatGPT is all very well and good, but this forgets what you were talking about after each chat. So it's good for 1 question and 1 answer. What we need is to train it a little a bit like the standard OpenAI Chat website does in terms of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
navigate through the HTML DOM. Here are some simple ways to do this: Object Name & Index Say you want to get the value of the 1st element in the 1st form, which will be the Search for Keywords Input Box. The path would look like this (a collection of...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
for convenience: InputBox, FunctionToDo, DLL File, Enter the name of the DLL file you want to (suffix with .dll):,,500,120,,,,,shell32.dll If not ErrorLevel { ThisData:=PE_FunctionExports( FunctionToDo ) IfExist, %A_Temp%\delete_me.txt FileDelete,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
To: Microsoft Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
:: copy symbolic links versus the target. /MT[:n] :: Do multi-threaded copies with n threads (default 8). n must be at least 1 and not greater than 128. This option is incompatible with the /IPG and /EFSRAW options. Redirect output using /LOG option for...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
relevant in this case, after all, all styling was removed... Here are two screenshots to demonstrate the issue: Screenshot #1: This screenshot is of the PDF preview of my HTML code where I've had to set the font size to 46pt throughout the template:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
this function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL" Version 2019 string fn_getMilesBetweenCoords(float p_Lat1, float p_Lng1, float p_Lat2, float p_Lng2) { v_MathPi =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 0.2; v_GrandTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 1.2; v_TotalTax = v_GrandTotal * 0.2; m_UpdateQuote.put("Tax",round(v_TotalTax,2));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v2 rather than a connector. If you use POST then this adds/creates a record and if it already exists you will get a {"code":1001,"message":"Item \"...\" already exists."}. Documentation advises that the payload is empty which is not true in my case....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *