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

10 October 2012 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 Not Yet Available". Unfortunately...

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 border-radius: 0 0 5px 5px; Harmless you might say. Works fine on a small page but I have discovered limitations with the majority of browsers when having to spread gradient backgrounds across a long page. It would appear to be fool proof because of the...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 Module Manager Paste the ID code you got from revolvermaps.com into the module parameter. Important Note: The ID it installs with is for my demo site. If you want to reset the visitor count and associate it with just your site, you'll need to visit...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there are a few more...

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

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Proposed Budget i3 PC under £200https://www.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 Windows 8 and wait for Windows 9, but in the meantime we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core CPU (...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 code that replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1 This method replicates the table in a...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft...

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your...

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

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

04 June 2013 := ItemCount - FileCount TotalFileCount += FileCount TotalFolderCount += FolderCount } Method #3: Standard Function with Loop -- input parameters: -- -- Folder=folder/file pattern. -- -- Subfolders=1 or 0 (recurse into subfolders or not) SC_Load(Folder,...

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

Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 different drives per user on a single computer. This one is by modifying the system registry, so if you aren't familiar with the system registry in MS Windows, you may need to find someone who is. How? As a proof of concept, let's see how to hide a...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. #SingleInstance Force ; Skips the prompt that a current instance is running and overwrites this one with a fresh instance of this program SendMode Input ;...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 5826|England How? You can see it in the code above but I'll give the run through using the country of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the exchange fields (or container) to apply this to Select the "Export...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 returning input Lots of confusing answers out there on the web but here's an all-in-one where I Open an AlertDialog designed with a custom XML layout Set the hint text of a specific user input field (EditText) Store the input in a TextView (invisible or...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 an AlertDialog designed by an XML layout file ("res/layout/dialog_edititem_photo"). The ImageView exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main Activity Java...

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

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla...

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

Joes Youtube Plugin (JYP) Downloadshttps://www.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.0.5- Tested for compatibility with Joomla! CMS v3.4.0 - Included instructions in description - Included license file - Date Uploaded: Thu, 12th Mar 2015 Download 1.0.4- Tested for compatibility with Joomla! CMS v2.5.8...

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