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 about is required, the following 106 results were found.

  1. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

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

  2. $_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

    Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for...

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

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

    with the code to retrieve your product key in Windows 7 with a small VB script file. There are other 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...

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

  4. Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    One called "strip_tags" crashed in the running of the query. The function that did work errored persistently complaining about the delimiter, create the function by running the following: SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF...

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

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

    -- 2012-04-27 -- this Friday -- 2012-05-04 -- next Friday -- 2012-05-04 -- next Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both...

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

  6. Can't play music after Firmware Update Version 3.0https://www.joellipman.com/component/content/article/cant-play-music-after-firmware-update-version-30.html?catid=116&Itemid=165

    Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 101 - 106 of 106