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 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 Joomla 1.5 admin...

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

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

07 July 2009 - any sort of whisk or even a fork will do - incorporating any bits of flour from around the edge of the bowl as you do so. Next gradually add small quantities of the milk and water mixture, still whisking (don't worry about any lumps as they will...

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

Using MetaMod to hide buttons from logged in usershttp://mail.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 and 'regmenu'. (Assuming you already have a menu - easiest thing to do is make the new menu in menu manager for reg users. Next, go to the module mgr and create a new menu module for the regmenu menu, mine are called - 'pubmenu' and 'regmenu'. Edit your...

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

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 of the GUI on each page until it confirms you've installed phpBB3. Install RocketTheme Affinity phpBB3 Style The next big step is installing the Affinity phpbb3 style. I say it's a big step because RocketTheme assume that you just upload the affinity...

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

Creating a Top 10 chart with less codehttp://mail.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 (for sorting purposes - eg. so 10 is not before 2) Store both the formatted count and the value of column1.table in the next array entry Reverse this array Display the first 10 rows of this array (if we are doing a top ten) My new method is: SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Some milestones for a website projecthttp://mail.joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 the saleability of the product and technical risk involved in fully developing the website. ALPHA/BETA – these are the next major milestones that represent near completed websites, these are subject to extensive testing, compatibility and QA by both the...

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

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

13 July 2010 get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had...

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

Create Read-Only Database User in SQL Serverhttp://mail.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 Properties. Select User Mapping. Map the login to the database they will have access to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names...

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

URL passed settings in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse button next to it to edit. Visit http://odetocode.com/code/128.aspx Issues encountered Note there appears to be an issue with regards to...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET...

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

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

29 March 2011 into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is hidden, the next textbox moves to fill up the space... There are some suggestions on the net but they didn't work or didn't apply for me. I had...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious...

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

Run commands for Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Utility msconfig System File Checker Utility (Scan Immediately) sfc /scannow System File Checker Utility (Scan Once At The Next Boot) sfc /scanonce System File Checker Utility (Scan On Every Boot) sfc /scanboot System File Checker Utility (Return Scan...

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

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 WM_QUEUESYNC = $0023 Const WM_GETMINMAXINFO = $0024 Const WM_PAINTICON = $0026 Const WM_ICONERASEBKGND = $0027 Const WM_NEXTDLGCTL = $0028 Const WM_SPOOLERSTATUS = $002A Const WM_DRAWITEM = $002B Const WM_MEASUREITEM = $002C Const WM_DELETEITEM = $002D...

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

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

05 July 2011 := COM_Invoke(pwb, "document.documentElement.innerText") There you have it! These techniques should help get you started. Next, I would recommend the following: Try these Controls out on some of your favorite webpages. Find some more JavaScript...

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

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

24 August 2011 the idea of requiring macros as not all users switch this on and teaching executives on how to do this is tough work. What Next? Permissions on EXCEL filters: Need to control for different levels of management? Could add a WHERE clause to the query so...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 } FormatTime, val, %val%, ddd dd-MMM-yyyy HH:mm:ss Return val } // returns format Sat 01-Jan-2011 01:00:00 The next function usually accompanies the above one. It will basically convert seconds into days, hours, minutes, etc.: FormatSeconds(val) {...

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

T-SQL Record Separatorhttp://mail.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 character. I just put NULL because I wanted an empty row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling...

• Type: Article
• Author: Joel Lipman
• Category: Transact-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 to your local folder; once done close the dialogs click on the TFS icon in Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

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

Battery Constantly Drained on iPhonehttp://mail.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 is a brilliant example where trying to fix the problem is the very cause of the problem in the first place: The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that needs to...

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