MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that...

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

The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 it is completely useless if your mistake is ancient history." - Learning GNU Emacs (page 42) Undoing can itself be undone. After having undone an action, you can redo it... - Docs.Gimp.Org Synonym: redound Latin - Etymology - From unda ("a wave")

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website addresses...

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

Ordered List of over 1000 Itemshttps://www.joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

08 February 2013 is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = @EmployeeStr -- yields 0 -- After (replacing the = with LIKE) SELECT COUNT(*) FROM Employees WHERE Employee.ForeName LIKE @EmployeeStr -- yields 1

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

Modifying columns in a tablehttps://www.joellipman.com/articles/database/modifying-columns-in-a-table.html

24 July 2013 a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn; MySQL and Oracle PL/SQL ALTER TABLE myTable MODIFY myColumn myDataType Microsoft Transact SQL (T-SQL) ALTER TABLE...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my...

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