Using a HTML form and PHP to upload a filehttp://mail.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 you passed in your HTML form. If the above yields NO empty data (and size is not 0) then it was successful. If not, then either your system isn't accepting the file type you are trying to upload, or the file is too big, or this feature just isn't...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a different host. If your website has been LIVE for a while and it's returning this error despite having little...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttp://mail.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 keep it alphanumeric) Now upload the template you just renamed into your phpBB3 styles folder: /phpBB3/styles/. You can either decompress on your computer and FTP upload the files uncompressed, or if you have shell access, upload the zip and extract it...

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 published => obviously by whether they're published or not... no idea why u would checked_out => sort by checked out (will either display or not on the front page so again not any use to sort by this) checked_out_time => just cos this value exists,...

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

Write a Calendar in Autohotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 a mix between HTML and autohotkey syntax (note we're making a table with 9 columns and 6 rows - there's a spacing column on either side): htmlText:="" htmlText:=htmlText " " htmlText:=htmlText "" htmlText:=htmlText " " htmlText:=htmlText " M "...

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

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 (rough layouts - can be on paper in pencil...) Discuss timelines / milestones (milestone= when a task is completed - it's either done or not) Submit all marketing, promotional material (can include fonts, images, word documents, etc) We can accept most...

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

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

12 July 2010 run the Unduplicater.ahk file) FUTURE CONSIDERATIONS: Compare the file sizes and delete based on this Specify to ignore EITHER suffix or prefix SCREENSHOTS: MORE DETAILS AS WELL AS COMMENTS/SUGGESTIONS: You can leave a comment or suggestion anonymously...

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

Webdeveloper-Speakhttp://mail.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 outcome. typosquatter A typosquatter is a company/individual that registers the misspelling of a popular website address, either to increase advertising revenue or as a form of parody/social criticism. initialism An initialism is a phrase or multi-word...

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

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

07 January 2011 note the following: SET DATEFORMAT dmy returns the date in European format irrespective of the regional settings of either the client or the reporting server. Removed @GivenDate datetime, from the SQL script Removed @GivenCampus varchar(100) from the...

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

Formatting a date in an MDX queryhttp://mail.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 Even Microsoft don't have helpful documentation on using SWITCH in an MDX query. Chances are they can't get it working either: Switch( Format(Fields!Date.Value,"d")=1,"st", Format(Fields!Date.Value,"d")=21,"st", Format(Fields!Date.Value,"d")=31,"st",...

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

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

28 April 2011 standard image. The printer was connected via three usb extension cables. The middle one wasn't connected to anything on either end. What not to say to IT "Hi could you find and tell them to unlock the record they are viewing". "Oh that person isn't at...

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

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

03 October 2011 So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely if you're using either Joomla or Wordpress that you have a PHP enabled server available. Here's code to top off the user migration, save it to an...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 "executed stored procedure", "please click on the link to continue" and then the user would be taken to a report which says either "Stored Procedure was successful" or "No sorry you're going to have to go back to the beginning and try that again."......

• 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 username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION function_name [ (parameter...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio v2008 (BIDS) SQL...

• 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 SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not...

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

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 JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as is without warranty If you do not understand what this script is...

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

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 We're going to use the onBlur and onFocus attributes which do, as the name indicates, trigger events when the cursor is either in the field or not. The above field was created with the following code: Explanation type="text" - standard attribute that...

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

Joes Revolver Map (JRM)http://mail.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 code they give you. Login to your Joomla website admin panel Create a new Custom HTML Module In the "Custom HTML", either disable rich-text editor or click on the HTML button Paste the code you got from revolvermaps.com into the "Custom HTML" parameter....

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

AwStats Data Parser (ADP)http://mail.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 allowed quicker reports then scanning entire website visitor logs. No installation and USB portable. Currently runs using either Windows XP or Windows 7. How to use: Save a frame of your Awstats page (so there isn't the menu on the left) Run...

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