Alternative method of displaying Unicode in Autohotkey GUIhttp://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ;...

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

SSRS Dropdown parameter cannot be blank!http://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 to the dummy value. For me it just opens an empty report with the charts saying "No Data Available" but I find this better then the alert message "parameter cannot be blank!" and less confusing to the end-user. If this bugs you, you can always include a...

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

Basic Oracle Stored Procedure Structurehttp://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 they're run from within a stored procedure. Our aim is to run a small query first to return the ID of the student, and then to use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR...

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

Prefix Line Numbers in a Text Filehttp://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The first line of my code...

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

Print Directory Contents to a Filehttp://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 but with some group policies, you will get an "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program and change the path in the above instructions accordingly.

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

Connect to Joomla database in standalone scripthttp://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 // Database driver name $db_host = $Config->host; // Database host name $db_user = $Config->user; // User for database authentication $db_pass = $Config->password; // Password for database authentication $db_name = $Config->db; // Database name...

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

Basic Joomla 2.5 Mootools Formhttp://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 Change www.YourSite.com - Yeah note the URL to the mootools-core-uncompressed.js file, if you have this enabled in Joomla then you already have this and don't need to include it again (just view the source of your webpage that this form will be on)....

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

Joomla article modal with clear buttonhttp://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 core ones, namely administrator\components\models\fields\modal\article.php and \libraries\joomla\form\fields\media.php. You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the...

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

T-SQL example of Case-Sensitive Soundexhttp://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data...

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

Search a database with SOUNDEXhttp://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 store it in a local variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output...

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

Stored Procedure to List Distinct Values and Countshttp://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Setup a copy of your Joomla websitehttp://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 environment for the website/application developers, a quality assurance environment for our clients to test these, and then a live/production environment that will be released for public use. This allows for a good test bed and stable releases, error...

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

Set up Desktop SlideShow in Windows 7http://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 Windows 7. Requires a Vogonian environment of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture...

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

AwStats Data Parser (ADP)http://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 Statistics [AwStats] v7.0 (build 1.971) report. The data file is used by my infographic script which allowed quicker reports then scanning entire website visitor logs. No installation and USB portable. Currently runs using either Windows XP or Windows...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

MS Excel - Sort pivottable column headings by datehttp://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses? Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to...

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

Autohotkey Count Number of Files/Folders in a Directoryhttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing (or whatever your script is trying to do). Method #2: FileSystemObject ComObjCreate UserFolder:="C:" --...

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

Split a row into multiple rows based on a column valuehttp://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 002 3.00 2000-02-18 1.00 003 2.00 1999-02-25 1.00 003 2.00 1999-02-25 1.00 If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the above example, the dates are...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

htaccess Rewrites SEF URL and submits to PHPhttp://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 structure. Slashes and underscores /_ are good (so regexp: /[^a-zA-Z0-9_\/]/). If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttp://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 const RECAPTCHA_VERIFY_SERVER = "api-verify.recaptcha.net"; Method #2 If method #1 didn't work for you then if the following code works, it's because Google have changed where they're storing the API (again). This overrides the Core Joomla code for...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the...

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