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

22 October 2010 database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take away accents and convert to ASCII), they weren't what we were looking...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 thing as you did in the report. I am looking at ways of doing this without logging into the reporting server or making any changes to it. If anyone knows of a way, please feel free to comment!

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 alert you when it's done. To see the image it created, go to File > and then select "Open Images Folder". Help If you make changes to the program, you'll need to re-run the Help. The Help will tell you what to correct but it doesn't currently refresh...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level parameter check Add IIF in SSRS to confirm Database Level AlphaNumeric...

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

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

02 December 2011 away which is the better report; and when comparing to the previous runs (using a second dataset) 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...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 brief as we've converted the seconds to time. -- Using MySQL to convert rather than PHP so as not to have to deal with hour changes and the magical 23:00 hour. -- 2nd Note: We use "WEEKDAY" instead of "DAYOFWEEK" as our working week starts on Monday...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 script, this will change the IDs of the JComments comments to be associated to articles from your Joomla 2.5 site (no changes to article IDs but backup your original database (J1.5) anyway before running the following): UPDATE...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing you to...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 DebugString, now, now, 0, emptyBytes); } } } Example #2: Refreshing a DLL This has to be repeated every time the code changes in the script: Build CS file in solution Check-in file/change Build Project Check you have a compatible Global Assembly Cache...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 my server to receive requests for those domains (along with webspace and emails). Please wait up to 3 hours for these changes to cascade across my servers (average wait is 1 hour). JoelLipman.Com will develop the startup site using an Agile framework...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 "Rule Abiding" variation as a strong password to use. Comments/Suggestions Please use the comment section below to suggest changes, corrections, improvements or just to give an opinion. Use it! It's absolutely FREE! The password analyzer URL is:...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 only. /256 :: turn off very long path (> 256 characters) support. /MON:n :: MONitor source; run again when more than n changes seen. /MOT:m :: MOnitor source; run again in m minutes Time, if changed. /RH:hhmm-hhmm :: Run Hours - times when new copies...

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

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 Y 16777216 1000000 Z 33554432 2000000 All Drives 67108863 3ffffff Log off and log on, or restart the computer to apply changes. Important! The above only applies to the user you are running Regedit as! (So if logged in as Admin, this hides it from the...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 corrects this. I personally downloaded HeidiSQL, setup a connection and exported the database. Job done without making any changes to the LIVE environment!

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

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

20 October 2014 the AlertDialog AlertDialog.Builder b = new AlertDialog.Builder(this); // set the view of the AlertDialog along with changes (eg. changed "hint") b.setView(v); // set OK button action b.setPositiveButton(R.string.button_ok, new...

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

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 textPassword // password type field textVisiblePassword // um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 (Joomla admin panel). The functionality and component are simply an extension to the existing Joomla Search. There are no changes to the existing component. Download You can download this module I made from my download section at...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 Panel (to check for and remove expired menu items) A good database administrator who is comfortable with making changes to the database Why? We have a page describing the company that we would want entitled "about" or "about-us" but these were already...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 I hope to refine one day where given a set of breadcrumb hyperlinks, when I hover the mouse over the links, the text changes and the transition between the two is controlled smoothly. Why? At time of print, I couldn't find any clear example...

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