Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 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: *

Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 systems are the usual suspects. Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

ZohoDeluge: Inserting a new line character in a CSVhttps://joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... What I have Me,Myself,I\na,b,c What I want Me,Myself,I a,b,c How? So in this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Another ASCII Extended Character Set for PChttps://joellipman.com/articles/microsoft/windows-os/another-ascii-extended-character-set-for-pc.html

14 April 2010 Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 to use a named pipes connection, "unix" for a Unix socket connection and "memory" to use MySQL shared memory. Specifying character set Use this one to specify which character set to use to encode queries sent to the server....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 Custom Service - on account server COM https://deluge.zoho.com/delugeauth/callback Problem: Split a string with the escape character/backslash character Trying to split a string into a list by the backslash character: v_File =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 #myScrambledTable 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 + '(' +...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 paint, palette knife, windsor & newton oil paints, award-winning style::3 signature, deformed::-2 cartoon: ::5 Whimsical character design::4 Tags: creative, expressive, detailed, colorful, stylized anatomy, high-quality, digital art, 3D rendering,...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Run commands for Windowshttps://joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 photoshop Automatic Updates wuaucpl.cpl Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk Utility chkdsk Clipboard Viewer clipbrd Command Prompt cmd Component Services dcomcnfg Computer...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Preg_Replace all strings between two tagshttps://joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 Hello $New_World $string_formatted = preg_replace( '/\$[a-z_]+/i','$0', $string_original); Replace all words with suffixed character Convert: Hello( World ) » Hello( World ) $string_formatted = preg_replace( '/[a-z]+\(/i','$0', $string_original);...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014... How? To do this in a select query resultset, you insert the special character references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to do this in the name of the column heading, the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 What? This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Deluge: Convert Hex to RGBhttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 some point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the given string...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote character to the beginning and end of the location of chrome.exe (for example: "C:\Users\My User...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 rtl, 1, '*', CONCAT( '{"show_feed_image":"",', '"show_feed_description":"",', '"show_item_description":"",', '"feed_character_count":"0"}' ), NOW(), @new_jos_admin_id, '{"robots":"","rights":""}' FROM `my_old_database`.jos_newsfeeds; --...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

List all cron jobs for all usershttps://joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 file and cron job directory. Change these for your system. CRONTAB='/etc/crontab' CRONDIR='/etc/cron.d' # Single tab character. Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace #...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 pictures. If you are batch processing a text file, you need to separate the website address and the given name with a pipe character ("|" - see "TEXT file example" mentioned earlier). It ignores spaces before and after any text. If you haven't specified...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *