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

04 December 2012 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 enabled. How? Basically you have to include &view=article as opposed to...

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

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

24 July 2013 modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL)...

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

MS Excel: Convert a text to a numberhttp://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 "₱", "") Which leaves the value as a literal string... Now the tricky part, how to copy into a column just the number? Even if I tell it to multiply by 1, Microsoft Excel gets confused and reports an error?!?!?!? The answer on the Microsoft website is...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 for each r_EntryID in l_AllowedEntries { input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a while. This is for error...datatype...

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