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 because some scripts are noticeably slow (as 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...

• 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 $didyoumean_words_array=array(); // Note: for some systems you can do a levenshtein on two words soundex value and compare these. // Be warned that it does go off track though in terms of relevance... Sources: iamcal.com Nadeau Software

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

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

29 March 2011 WHERE re.RoomId=@GivenRoom AND re.SetId=@setId Reminder: The counter = 1 means that if I call on the sum of these, I can check if zero rows were returned because Sum(Fields!Counter.Value, "Equipment") should come back as zero. MDX Expression: One final...

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

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

01 March 2011 site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs group. These are staff who take lecture notes for people of all disabilities and assist the students for the duration of their course. It...

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

List all cron jobs for all usershttp://mail.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab file and cron job directory. Change these for your system. CRONTAB='/etc/crontab' CRONDIR='/etc/cron.d' # Single tab character. Annoyingly necessary. tab=$(echo -en...

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

Could not instantiate mail functionhttp://mail.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname must not match any domain that is being used on the system....

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

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

07 July 2011 a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compatibility and actively developed. Unfortunately hacked on more than one...

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

SSRS Querying on either of 2 Parametershttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 so that's a lot of rows, possibly all unrelated and won't work in my particular case. The solution to this issue of these solutions would be to add another AND clause where you state that the ID (DB.Table.StudentReference) can NOT be blank/null....

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

SSRS / MDX Date Querieshttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html

03 August 2011 been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's...

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

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

08 August 2011 total 3 of the columns (which measure in milliseconds) and convert to a time value with milliseconds showing. Now why don't these match? Using in an aggregate, how do I get the milliseconds between start and end times instead of summing the remaining...

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

MySQL parameters in Excel 2007 PivotTableshttp://mail.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 1 so this is not inclusive). Crude solution but it works in Excel 2007 Now we want to filter the pivotTable data based on these two values... (I don't like the idea of requiring macros as not all users switch this on and teaching executives on how to do...

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

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

02 September 2011 our stored procedure with the parameters specified just after the name of the procedure. The trick is not to use any of these and to use the GUI dialog of the "Dataset Properties" for that stored procedure. The variable values will be prefixed with @...

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

AutoHotkey Format Date and Format Secondshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...

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

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

30 September 2011 the person who knows how to hit the refresh button is the one to save as a PDF file and sends it to all customers. Training these people in adjusting row height would be like a magician revealing the secrets to his tricks... no it wasn't really, time...

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

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

14 December 2011 d1.Name ASC Additional Modifications: For all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" = Select the dataset of the dropdown options. »...

• 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 returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services...

• 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 files would not need to be modified. So? Once installed, my BIDS install would continuously check-out files and store these in the home directory. I tried the general settings (Tools > Options) but to no avail. How? The way to change this was: Connect...

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

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

27 April 2012 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 $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT...

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

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

21 August 2012 and the field returns to displaying "Name:". Why? I've noticed a lot of solutions now use JQuery or Mootools but most of these will not work in Internet Explorer 7 which is unfortunately still in use. I needed a back-to-basics solution and this is the...

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

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 column we have setup default values, let's use the 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...

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