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

25 February 2011 that have NOT been approved yet... So would this work if I switched MyTable1 with MyTable2? Um I'll get back on this article when I work this out without using two SQL scripts. Currently I've returned to the process where one SQL query returns all...

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

PHP & MySQL Search Enginehttp://mail.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 AJAX suggestion feature (be flexible with us as some customers have asked how does it get that word and why is it relevant? (when it isn't, the sound matches and then it's a typo on the sound so it matches words that are vaguely similar instead of spot...

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

Difference between two dates - the midnight hourhttp://mail.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider...

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

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

23 April 2011 a scrollbar at the bottom. Tried different techniques of CSS overflow auto hidden etc. all to no avail. What I didn't want when I resize the web browser, a scrollbar! What worked for me: Specify the DIV layer width to be 100 percent of the page....

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

Newbies guide to be the local computer guyhttp://mail.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 to build up a client base and get some referalls. Put up a Web site describing your services. It makes you look more legit when you print it on your business cards. Hit up local colleges and post flyers there. If you’re going to market to college...

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

The ReportServer Databasehttp://mail.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 running the report (eg. MYDOMAIN\myusername) RequestType bit NOT NULL User or System. Can be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS Internet...

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

Importing Joomla articles to WordPress postshttp://mail.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 created 'post_date_gmt', CONCAT(introtext, ' ', `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status', 'open' comment_status, 'open' ping_status, '' post_password, alias...

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

Excel PivotTable Filter List Orderinghttp://mail.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all available values listed. The Problem The values are listed in...

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

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

03 October 2011 a.email AS 'user_email', ' ' AS 'user_url', a.registerDate AS 'user_registered', ' ' AS 'user_activation_key', CASE a.block WHEN 0 THEN 2 ELSE 0 END AS 'user_status', -- NOTE THAT THIS IS DEPRECATED IN WORDPRESS 3.X a.name AS 'display_name' FROM...

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

SSRS Zero Paddinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 Situation We have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An Oracle error usually returns in the format of...

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

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 a horrible report which would fail an accessibility test but visually it says straight 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...

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

Basic Oracle Function Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); END...

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

How to change local folder for TFShttp://mail.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to use a common local directory for all workstations so...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

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

07 June 2012 isgood, ispoor, published, subscribe, source, source_id, checked_out, checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',',...

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

Print Directory Contents to a Filehttp://mail.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you right-click on an object). The following is a method of adding this as a single command similar to how we add the...

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

The Mermaidhttp://mail.joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 a Friday morn when we set sail And our ship not far from land, We there did espy a fair pretty maid, With a comb and a glass in her hand, Her hand, her hand, With a comb and a glass in her hand. While the raging seas do roar, And the stormy winds do...

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

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE ',' + COLUMN_NAME + ' ' + DATA_TYPE + '(' +...

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

Vertically align an asterisk on a linehttp://mail.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 the same row. The problem afterwards was that the asterisk character would overlap the item beneath it (in this case #2) so when a user clicked on #2 they would in fact be clicking on the item containing the asterisk above it. Objective Box List Before:...

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

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

10 October 2012 example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice, especially when the case is different, eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server...

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

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 to your development environments, eg. http://dev1.mysite.com, http://dev2.mysite.com, http://qa1.mysite.com. When working with a FTP client this also helps as all you are usually changing is a folder name in order to quickly point to LIVE or TEST....

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