Cranberry flapjackhttp://mail.joellipman.com/articles/_other-misc/cranberry-flapjack.html

07 July 2009 on each side until golden. 4. For the caramel sauce, in a hot pan, add the butter and sugar and cook for 3-4 minutes. Then add the cream and orange segments. 5. Serve the flapjacks with the caramel sauce.

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

Peanut Butter Milkshake Recipehttp://mail.joellipman.com/articles/_other-misc/peanut-butter-milkshake-recipe.html

05 September 2009 wish (I use 1 cup); pour into blender, and add the vanilla and peanut butter. Whirl for 1 minute; add 2 scoops ice cream, then whirl 1 minute more. Servings: 1 Source: http://www.recipes-4u.co.uk/drink/Peanut-Butter-Milkshake.html

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

Can't play music after Firmware Update Version 3.0http://mail.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable the multi-audio output then you can play music again. What a bummer you can't play music and use anything else anymore. I can still play some games and...

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

Migrate MediaWiki to another serverhttp://mail.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from maintenance folder after updating AdminSettings.php More Information...

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

Windows 7 and Google Chrome incognito mode by defaulthttp://mail.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 Additional Note 201004201256: The shortcut key within Google Chrome is holding down the Control and Shift key and then pressing the letter N.

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

Another ASCII Extended Character Set for PChttp://mail.joellipman.com/articles/microsoft/windows-os/another-ascii-extended-character-set-for-pc.html

14 April 2010 while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN character: Hold down while typing "0" then the decimal number on the keyboard keypad. (Example: 0140)

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

AutoHotkey Ternary Operatorhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 moment on how to use ternary operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For...

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

Invalid arguments passed in router.php on line 325http://mail.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the router.php file. Mine was generated by...

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

Border settings not saving in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then define which border (top, right, bottom, left) the settings apply to... Mad. 1. Type your expressions/specify color first:...

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

Set default parameter dates to start and end of monthhttp://mail.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling and reading up on is...

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

F_ck You. Pay Me.http://mail.joellipman.com/articles/web-development/fck-you-pay-me.html

14 April 2011 appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco, CreativeMornings (creativemornings.com) was Mike Monteiro, Design...

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

Mouseover Links in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 AutoHotkey file, you'll find this is remarkably temperamental. If the user is too quick with their mouseovers and mouseouts, then the GUI will sometimes leave the link as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers:...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttp://mail.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM a_pretend_table WHERE...

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

MediaWiki: MySQL to extract path to imageshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the...

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

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both saturday and sunday returned week ending date as next week). If you were starting...

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

Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

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

Drop If Object Existshttp://mail.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 various websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the...

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

Mootools - How to contain a menu sidebar between header and footerhttp://mail.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 = 'relative'; $('jdo_actions').style.top = '0px'; } } }); // still to do: smoothscroll? if already overlaps then flicks up

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

The greatest invention in IThttp://mail.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be...

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

Deserialization and cannot checkout files in TFShttp://mail.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any file in the Solution Explorer Go to File » Source Control » Go...

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