Sir James Dyson explains his bladeless fanhttps://www.joellipman.com/articles/_other-misc/sir-james-dyson-explains-his-bladeless-fan.html

30 October 2009 I love technologies that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other...

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

Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

06 November 2009 If you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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

On Gui Resize Eventhttps://www.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 Thought I'd put this down as it took me ages to search the Internet for this solution. In the end, I found it hidden away in the Autohotkey help file and not under the gui events... The issue here is if you want to do something when a user resizes your...

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

Add default to a picture buttonhttps://www.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 Well there's a lot of autohotkey sites saying that you can apply a transparency and then capture special mouse events to emulate the mouseover and mouseout effects of a button with an image as a background. I couldn't get any of these working and they...

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

Guitar Practicehttps://www.joellipman.com/articles/_other-misc/guitar-practice.html

14 November 2009 Not my type of music but 65million hits have gotta mean something. {youtube}QjA5faZF1A8{/youtube}

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

After installing rokstories, get invalid argument 106https://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 After I installed the rokstories module from www.rockettheme.com, if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in...

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

Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 Applies to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Outputting PHP files into different file formatshttps://www.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

12 February 2010 I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...

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

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

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

Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

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

Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share...

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

Joomla - How to preview module positions in a given templatehttps://www.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 yourdomainname.com is your domain address and thetemplatename is the name of the template (without spaces). e.g. http://joellipman.com/index.php?tp=1&template=rt_affinity_j15 Or watch this boring video I made showing you how to do it:...

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

How to make your Joomla site use SEO friendly urlshttps://www.joellipman.com/articles/cms/joomla/how-to-make-your-joomla-site-use-seo-friendly-urls.html

02 April 2010 Basically so that you can set all those SEO settings in the global configuration tab to YES. Note: you need the permissions to rename the file ("htaccess.txt" to ".htaccess" in your website root folder). You'll need ftp access or a file manager with...

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

Gavick - How to add a navigation menu to Image Showhttps://www.joellipman.com/articles/cms/joomla/gavick-how-to-add-a-navigation-menu-to-image-show.html

07 April 2010 We'd lost the menu/browsing interface button panel (well i had). This is how to make sure it shows on the template style and how to position it on the image slide show module that comes bundled with the extension.{youtube}qOWGxgyoqA4{/youtube}

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

Another ASCII Extended Character Set for PChttps://www.joellipman.com/articles/microsoft/windows-os/another-ascii-extended-character-set-for-pc.html

14 April 2010 Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

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

AutoHotkey Ternary Operatorhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 Just a quick note for the moment on how to use ternary operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most...

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

If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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

Change Regional Settings for your Reporthttps://www.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...

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

Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...

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