Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 this is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all legitimately :)...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name:...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 "DataSet1") returns the maximum number of rows retrieved Yields something like: This is the bottom left of a report where both the above examples (fill and borders) have been applied:

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

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 observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like. I like queries against...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 Room 08:00:00 09:30:00 2 Note that [Test1 Room] will appear as a row but have no slots booked against it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above to 30 minute slots). Tweaks Separate the field @GivenDate...

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

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 CSS: #contentbox { position: relative; top: 70px; width: 900px; margin: 0 auto; padding: 7px 30px 75px 30px; clear: both; z-index: 7; /* Fallback for web browsers that doesn't support RGBa */ background: rgb(255, 255, 255); /* RGBa with 0.6 opacity */...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• 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 "No it takes so long in the morning, this is quicker". Explained how logoff is not the same thing as restart and reminded on both IT and environmental policies. Tech Notes: For PCs: Run a command prompt and type systeminfo: Look for "System Up Time". A...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development and production, means that anyone with access to the Excel spreadsheet can go and view the connections and see...

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

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

03 October 2011 database and change my_joomla_db to the name of your joomla database. Note that your database user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email,...

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

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

07 November 2011 is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND...

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

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

14 December 2011 parameter untouched (=""), the report complains saying "Report #3 parameter cannot be blank!". Before you ask, I have ticked both "Allow Blank" and "Allow NULL". How? This is the tough part. I was reading up on the MSDN page for the closest solution but...

• 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 DBA responsible for the system asked me to look at ways of reducing the load on the server and the solution was to separate both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the work: User Query...

• 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 Admin interface. If the article IDs match then the comments will also match. If however your article IDs don't match in both versions of your site, consider using the following update script, this will change the IDs of the JComments comments to be...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ ', ' '))) IS NULL THEN -- Determined submitted value as 'ALPHABOTH'; v_rand_param1 := 'A'; v_rand_param2 := LENGTH(p_original_value); v_returnedval := DBMS_RANDOM.STRING(v_rand_param1,...

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

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

11 October 2012 first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has two rows, both with the typo: ** ** Row1: EthnicCode DnYa ** ** Row2: RegionCode DnYa ** ** -> Only Row1 will display in column source as...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• 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: *

Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery and MooTools) conflicting with other scripts but do I...

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

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 if that works. Check your cookie policy: Open a browser which allows cookies, and one that does not. Visit your site with both and attempt the password change.

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM...

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

Compare two databases using T-SQLhttps://www.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which...

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