UTF8 Unicode PHP MySQL for International Charactershttp://mail.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed funny characters. The Joomla! articles were displaying the correct characters for that language set. I needed to make my...

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

Passwords: Did-you-knowhttp://mail.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 as well... You can opt to have these protected by a 'Master Password' but by default and without this, Firefox will display them all at a click of a button. (source: n/a 08/2008) Password recovery tools for the majority of popular programs we use today...

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

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 that separates the textboxes (so fills up the empty space with an object)... The visibility expressions for both hiding and displaying either the textbox or the tablix has to be applied to both the textbox and tablix (as tablix doesn't show if resultset...

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

Checklist for the local computer repairshttp://mail.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 performance during troubleshooting Note background and visual settings to restore after troubleshoot Run Task Manager and display “Performance” tab. Check user profile size. Recommended quarter of physical RAM (eg. x Accessories > System Tools > Disk...

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

Sort order a dropdown list in MS InfoPath without programminghttp://mail.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 of this list you want to use (only really need ID and Name or just the one if your dropdown values will be the same as the display labels) Next > Next > Finish My Google Searches (ignore this, it's for me): infopath look up values sharepoint list sort...

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

Migrate Joomla Users to WordPresshttp://mail.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) SELECT a.id 'ID', a.username 'user_login', REPLACE(TRIM(LOWER(a.username)), ' ', '_') AS 'user_nicename', a.email AS 'user_email', '...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 select to check that the update happened. Unfortunately this means that when the report was executed, it could only really display a message saying "executed stored procedure", "please click on the link to continue" and then the user would be taken to a...

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

Performance Report - Background colors based on dataset valueshttp://mail.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 you can tell where changes were made and how this affected the reports' performance. What? What I'm trying to do is display a set of results (comparing various reports) in a table and then to color the backgrounds based on whether they are the fastest...

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

No rows returned in Oracle causes SP to failhttp://mail.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 don't want to return any rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply...

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

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

11 October 2012 a table has two rows, both with the typo: ** ** Row1: EthnicCode DnYa ** ** Row2: RegionCode DnYa ** ** -> Only Row1 will display in column source as this is first alphabetically. ** ** Correct the value for EthnicCode and re-run the code. ** ** ** **...

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

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

20 November 2012 figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the white background would disappear when the page finally loaded. How? The root cause was because the...

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 the format schtasks /run /tn "task-name" schtasks /run /tn "VisualStudio2010" and click on Next Give the shortcut a name to display as (eg. "Visual Studio 2010") Click on OK to complete your shortcut. Additional: You can change the icon for the shortcut...

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

SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 would make the report spin for about 10 minutes without the possibility to cancel (link not working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 your Joomla Administration panel Components > JComments > Settings > Layout > CAPTCHA > RECAPTCHA Save the change. STEP #5: Display recaptcha in comment form This step displays the ReCaptcha on the form (note this code may need to be reverted if the...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 your Joomla Administration panel Components > JComments > Settings > Layout > CAPTCHA > PLAYTHRU Save the change. STEP #5: Display PlayThru in comment form This step displays the PlayThru on the form (note this code may need to be reverted if the admin...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 your Joomla Administration panel Components > JComments > Settings > Layout > CAPTCHA > PLAYTHRU Save the change. STEP #5: Display PlayThru in comment form This step displays the PlayThru on the form (note this code may need to be reverted if the admin...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 to loop through and select it. Set the connection manager name, specify columns as per usual. OK the connection manager and display its "Properties" Under Expressions, click the ellipsis Under Property, select "ConnectionString" In Expression, type...

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

Batch Process to rename multiple files using Windows DOShttp://mail.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 to !newName! REM RENAME "!oldName!" "!newName!" ) Save the file Return to the command prompt and type rename.bat This will display all the files to be renamed Return to the notepad (rename.bat) and take out the remark "REM" prefix so your code becomes:...

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

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

20 October 2014 A quick article on how to display a OK/Cancel popup which I use as a message to the user for debug purposes. Why? It's similar to javascript's message box or confirm box, only Android let's you redesign the dialog. For my purposes I have used an XML as...

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

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so hopefully this will help others. How? The gist is that I...

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