Code Troubleshooting Checklisthttps://joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 solution and seeing what you can derive from that ("working backward") If the problem is abstract, try examining a concrete example. Try solving a more general problem first.

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Oracle SQL - Convert given list (CSV) into Rowshttps://joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 DUAL) x, TABLE (XMLSEQUENCE (EXTRACT (x.xmlval, '/rows/row'))) d Yields: 1 2 3 4 5 6 Note that I actually used text in the example above and this worked. Obviously don't get the commas mixed up.

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

MySQL day of week ending on Fridayhttps://joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on...

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

Joomla field types clear my htmlhttps://joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 following. How? So it's the field on the XML file /models/forms/whatever.xml which needs the filter=raw attribute, for example: Other searches: Stripping HTML from my joomla 2.5 component Leave my HTML alone for admins field types for Joomla 1.6

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

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

26 October 2012 Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE...

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

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

08 February 2013 What? So many people asking this when the solution 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: *

Convert Decimal (Person Days) to Time in Excelhttps://joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula: -- Given Cell B5 = 0.14 person days from above example. -- 1 person day = 26640 seconds and 1440 minutes = 24 hours. -- 0.07 person days = 30 minutes or 0.14 person days = 1...

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

SQL: Use CASE for Relevance columnhttps://joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...

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

A for loop within a for loop in MS-DOShttps://joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation...

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

SSRS Change Background Color of Imagehttps://joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 image to use. The image can be an expression as well (I embed these and then refer to them in the expression by name). For example: =IIF(Fields!SummaryStatus.Value="Success", "status_ok", IIF(Fields!SummaryStatus.Value="Unknown", "status_unknown",...

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

VBScript to retrieve Windows Product Keyhttps://joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows 10 operating system offered as a free upgrade (for Windows 7...

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

Zoho Deluge - Pad with leading Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 article later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber),...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 A super quick article to demonstrate an example where we create a project with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather than requests. Sure it lists fields that are required in the...

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