Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 - Do not pick on other members. The worst kind of bullying is where new members are picked on. This hurts the member as well as the board. No Flaming - Flaming harms the nice atmosphere of TEU. It also causes thread's to go off topic, and most...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 I have tried the method below with both an article and a contact page, but it should work for most other page redirects as well. Step Two: Next if you don't already know the URL of the page you want to redirect to, you will create a menu item in the...

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

Pancakeshttp://mail.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 the flour and salt into a large mixing bowl with a sieve held high above the bowl so the flour gets a airing. Now make a well in the centre of the flour and break the eggs into it. Then begin whisking the eggs - any sort of whisk or even a fork will do...

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

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 should not be able to send a 1000 queries a minute or why a developer has to refresh the page, make a change, upload, etc. well it's beyond a joke and no one should waste their time with such companies.

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

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

15 November 2009 most recent). I'm going to show you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla...

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

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

25 February 2010 Domain Registration Services (for .com, .net, .org, etc) - Note you can use the above UK ones for .com domains as well. http://www.networksolutions.com/ http://www.register.com/ http://www.godaddy.com/ http://www.cleverdot.com/ Domain Registrars for...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttp://mail.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 nice site with everything working as it should. It's templates are ok but it's its extensions for which I signed up for. As well as helping another subscriber. There were issues with some modules but the forum is frequently administered and the response...

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

Remove write-protect from USB pen in Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 3.57Mb). I have tried other rescue programs which caused even more errors (had to return the pen for another and another) as well as the common USB disk storage format tools for Windows. Note that any data on the USB pen is automatically lost, and that...

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

Error during processing - Converting Date/Timehttp://mail.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

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

Is it a scam? Gumtree.com's warning signshttp://mail.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 don’t follow any links provided in the email. Payment or protection services allegedly offered by «CompanyName» or other well known sites such as eBay or PayPal. You get an email that claims to be from «CompanyName», eBay, PayPal or another company and...

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

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

28 October 2010 Well this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the...

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

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

15 November 2010 > security > Saved passwords > Show All. This includes a feature to search through your saved password information as well... You can opt to have these protected by a 'Master Password' but by default and without this, Firefox will display them all at a...

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

Alternate row background colour in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as well. I want a bigger border at the bottom of the overall report and a light one to divide each record. Staying within the properties...

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

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 880 rows 0.187s STATEMENT2 741 rows 49.933s STATEMENT3 741 rows 48.844s STATEMENT4 741 rows 49.603s And Vice-Versa? Well actually I wanted all the articles that have NOT been approved yet... So would this work if I switched MyTable1 with MyTable2? Um...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 might already have something similar to this but this deserves its own article. Why? Well 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...

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

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 some of your favorite webpages. Find some more JavaScript examples, and then try "translating" them to COM. (JavaScript is well documented online) Learn additional ways to access the HTML DOM. You may be wondering, "How do I find information about the...

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

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

03 August 2011 ranges endlessly as I've 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...

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

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 data field, [ReportName] will be the series field and [DayOfYearRun] will be category field: So is this doing what I wanted? Well NO. I have a table with the same report mentioned several times but just in a different week. I want a returned table...

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

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

02 September 2011 SSRS was complaining about assignment targets not being valid (despite knowing what they are). Searches that got me nowhere Well not entirely true, there were solutions and tidbits but everyone had a different setup to us and their solutions were...

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

Alternative method of displaying Unicode in Autohotkey GUIhttp://mail.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 Well yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25)...

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