Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming example is required, the following 175 results were found.

  1. A for loop within a for loop in MS-DOShttps://www.joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    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

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

    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 Deluge
    • Language: en-GB

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

    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

  4. Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/component/content/article/windows-7-and-google-chrome-incognito-mode-by-default.html?catid=61&Itemid=165

    spaces in that value, you should add a double-quote character to the beginning and end of the location of chrome.exe (for example: "C:\Users\My User Name\AppData\Local\Google\Chrome\Application\chrome.exe" -incognito) Additional Note 201004201256: The...

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

  5. SSRS Change Background Color of Imagehttps://www.joellipman.com/component/content/article/ssrs-change-background-color-of-image.html?catid=75&Itemid=165

    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

  6. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    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

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

    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: *

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

    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

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

    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

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

    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: *

  11. Code Troubleshooting Checklisthttps://www.joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

    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: *

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

    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: *

  13. Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  14. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    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

  15. Splatter Logohttps://www.joellipman.com/component/content/article/splatter-logo.html?catid=115&Itemid=165

    on Create a new layer beneath Go to Selection > Modify > Expand > 10 px Fill this selection with another color (in the example below: dark grey) Add the brush with the same color to that layer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 161 - 175 of 175