Anti-Spam override for all submitted datahttp://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as JezRecaptcha), then the website security isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it...

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

MySQL Data Type Reference Tablehttp://www.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only...

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

Windows Live Messenger: Error 80048820http://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock was successfully synchronized... You can opt to untick...

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

Crystal Reports: Exporting to Excel omits column headershttp://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...

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

RokDownloads Manager does not list fileshttp://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 am in the middle of writing a component that will hopefully comprise bug-tracking and download management all in one. Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this...

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

Passwords: Did-you-knowhttp://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 of free nice USB flash drives in the parking lot. Employees pick them up and plug them into their machines at work which then sends the details over the internet. Apparently this has a 9 in 10 chance of working. Possibly the most notable in 2008 being...

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

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

05 January 2011 I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence...

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

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

25 February 2011 stage where we need to optimize the queries 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...

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

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

09 March 2011 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 on). $didyoumean_words_array=array();...

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

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

06 April 2011 Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the date: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession'])); $this_time_from1 = date("H:i",...

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

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

01 March 2011 during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error logs... some 20000 errors per use of a feature over 4 seconds. Do some developers never check the...

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

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

27 April 2011 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 using the Joomla! CMS Extension Manager. I'm going to call the folder "profile5" (without the...

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

Checklist for the local computer repairshttp://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your data backed up for $75. Then, I’d charge them $150 for “forensic data recovery” with “no guarantees” – while recovering from the backup I’d made...

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

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

28 April 2011 I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this is all I could fix in the time I have, all your issues have been dealt with and I also did this..."...

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

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

28 April 2011 not working". "From my logs, you haven't restarted this machine in a while.". "No I definitely log off every evening and then back on again". "You mean you log back on in the morning?" "No it takes so long in the morning, this is quicker". Explained how...

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

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

09 May 2011 Mailer settings). Alternate between PHPmail and sendmail just to check this isn't the problem. If the problem is still there then check the below: Tried both PHPmail and sendmail So if this happens irrespective of whether I have PHP mail or sendmail set...

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

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

21 July 2011 Look up values from an external data source Next to "Data source" click on Add Select "Create a new connection to" and then Receive Data Select SharePoint library or list Copy the URL/web address from your browser which has the datasheet open (eg....

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

SSRS Redirect after a report is runhttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions out there,...

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

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

20 September 2011 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 ) { FormatTime, FormattedTime , TimeString, %Format%...

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

Fun with DllCall in AutoHotkeyhttp://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run contained in the program and can be hidden from the end-user. The one to rule...

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