Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables...

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

Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 `old_db`.`old_content` AS old ON new.`id` = old.`id` SET new.`images` = JSON_SET( COALESCE(new.`images`, '{}'), '$.image_intro', JSON_EXTRACT( CASE WHEN JSON_VALID(old.`attribs`) THEN old.`attribs` ELSE '{}' END, '$.spfeatured_image' ),...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Intro I know there are a lot of articles on the WWW detailing this process but none of them really worked for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked...

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

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

30 January 2011 Exciting because this is not a simple 1.5.21 to 1.5.22 upgrade. But don't believe the drama across the web, the system introduces only a few new fundamental improvements (particularly Access Control and Groups) which actually only means some minor...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day in the life of New York City". {module title="Youtube Embedded Video - Sandpit"} More Information...

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