Convert a delimited string to tablehttps://joellipman.com/articles/database/convert-a-delimited-string-to-table.html

26 October 2012 = CONVERT(xml,'' + REPLACE(@myStringToParse,',','') + ''); SELECT [Value] = T.c.value('.','varchar(20)') FROM @myXml.nodes('/root/s') T(c);

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

List last modified files using FTP Command-linehttps://joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 dir (lists files & folders in the current remote working directory) Type cd /path/to/my/website to change directory to the root folder containing your website. Type pwd to confirm the remote working directory is the current directory. Type lcd to...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Free Translator API using Googlehttps://joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 module in your Joomla site. Add the meta tag they give you to your index.php file (under template folder in effect or your root index.php - wherever you have jdoc:include type="head") Done!

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients) Find the file htaccess.txt and rename it...

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