Joomla: Unable to find install packagehttps://www.joellipman.com/articles/cms/joomla/joomla-unable-to-find-install-package.html

05 September 2009 was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and double-checked the server settings for a...

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

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in...

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

On Gui Resize Eventhttps://www.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the image repeating... so use moveDraw which redraws the app. This will result in...

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

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

24 March 2010 Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share...

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

AutoHotkey Ternary Operatorhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there are a whole bunch of methods using the Ternary Operator in AutoHotkey (discussed on http://www.autohotkey.com/forum/topic29752.html) which I'll put in soon. I...

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

If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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

Change Regional Settings for your Reporthttps://www.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...

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

Phonetic and Morse alphabethttps://www.joellipman.com/articles/_other-misc/phonetic-and-morse-alphabet.html

06 January 2011 was using this for a password security-level checker: Source: www.wikipedia.org

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

Tim Minchin - 1984https://www.joellipman.com/articles/_other-misc/tim-minchin-1984.html

16 April 2011 brilliant Tim Minchin using my favourite book as a response to "the Big Fat Quiz of the Year" show hosted by Jimmy Carr. {youtube}CZ7U3Cu4Mr4{/youtube} https://www.youtube.com/watch?v=CZ7U3Cu4Mr4

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

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 you open other similar files in the same environment? Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE (...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution...

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

Convert seconds to total time in PHPhttps://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 I know to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":";...

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

Convert a delimited string to tablehttps://www.joellipman.com/articles/database/convert-a-delimited-string-to-table.html

26 October 2012 the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname'; SELECT @myXml =...

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

Joes Youtube Player (JYP)https://www.joellipman.com/component/content/article/joes-youtube-player.html?catid=40

31 December 2012 Install this plugin using your Joomla Admin Panel Go to Extension Manager > Search for "Joes Youtube Player". Enable and Save. Screenshots Looking forward to your feedback!

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

Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 -- or split for clarity TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written:...

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

A for loop within a for loop in MS-DOShttps://www.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 MS-DOS batch programs is a lot easier and colleagues trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the...

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

SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 link at the bottom of the left menu Click on the “All People” link at the top of the left menu Find yourself in the list by using the iccle arrow next to the 0-100 (top right) Click on your own name or picture to see your profile page Click the “Edit...

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 with the credentials stored, here are the details to our report As developers, we connect to the datasource directly using our Windows Credentials. For the SSRS server holding our report, we do NOT have an unattended service account. The report uses a...

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