First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10...

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

MediaWiki: MySQL to extract path to imageshttp://mail.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 IThttp://mail.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 articlehttp://mail.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 Itemshttp://mail.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 SSIShttp://mail.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 tablehttp://mail.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 Homehttp://mail.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: *