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 and Slovak. Fingers crossed this should work for all characters that Joomla! can handle by default anyway. Cause: Q. Why does this work for Joomla! articles and not for this module? A. Think this is because that module is loaded before... not sure but...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Use this one to specify a default command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object....

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 Builder 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US format as opposed to European...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 Resolved this by clearing my web-browser's temporary files. Do we instruct all users viewing the reports to do this? When does this report automatically expire? Reminder on Paper Sizes A4 = 8.27in (width) × 11.69in (height) Letter = 8.5in (width) x 11in...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 where one SQL query returns all possible results and the PHP script runs another SQL query for each row to check the ID does not exist in the audit table... -- Note: This article was updated on 2011-04-19 11:54

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 Hungarians). Fellow students and system administrators could not accurately describe what the system was for and what it does. The developer had created the system to only last during one academic year, and the system itself only just about understood...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 my clients want. Fortunately for me, I just created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to shove all these files into a folder which I will then compress and install...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 you're asking.". "Is it a networked printer, I mean is there a cable that directly connects the printer to your computer or does the printer plug into the wall? Ok could you please follow the cable from the computer to the printer and tell me.". "Hang...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 address?) --- Priority (High, Medium, Low - configurable in settings) --- Impact (free-text message by developers -> who does this affect?) --- Progress Status (acknowledged, testing, qa [=awaiting customer], resolved, postponed) --- Progress Indicator...

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

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

21 July 2011 the sharepoint list, and it had re-ordered to what I set in the view!!! I don't really understand how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list but needed to list elements in...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 prefixed with @ for SQL Server and not the colon (:) we expected for Oracle. Passing in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 day and then subsequently marked with the separator marker of Stage #1 (note that here separator marker is marked by day1 does not equal day2 rather than a column called marker): --Create CTE WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 This script is provided as is without warranty If you do not understand what this script is doing, let someone who does run it instead INSTALL INSTRUCTIONS Install JComments on your upgraded website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4)...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 if Given Value is date IF ISDATE(@OrigVal)=1 SET @ColumnTypeIsDate = 1; -- Determine if Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal,...

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

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 you have to be a paying member to access these and I tend to piggyback on my client's subscriptions. This information does not come from Yootheme forums. I am too lazy to answer/update my solutions in 3rd-party forums.

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

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 if Given Value is date IF ISDATE(@OrigVal)=1 SET @ColumnTypeIsDate = 1; -- Determine if Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal,...

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

SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 Professionals", just a piece of paper and proof you're good at theory IMO, no credit for being the tape monkey that does all the actual work.

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

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

12 April 2013 Wednesdays come before Mondays... but what's wrong with this equation? You can tell me that "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional The TRIM in SSIS does not appear to get rid of new line and carriage return symbols!!! Use the Replace(String, "\r", "") and Replace(String, "\n",...

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