Split a row into multiple rows based on a column valuehttp://mail.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 002 3.00 2000-02-18 1.00 003 2.00 1999-02-25 1.00 003 2.00 1999-02-25 1.00 If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the above example, the dates are...

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

htaccess Rewrites SEF URL and submits to PHPhttp://mail.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 structure. Slashes and underscores /_ are good (so regexp: /[^a-zA-Z0-9_\/]/). If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttp://mail.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 const RECAPTCHA_VERIFY_SERVER = "api-verify.recaptcha.net"; Method #2 If method #1 didn't work for you then if the following code works, it's because Google have changed where they're storing the API (again). This overrides the Core Joomla code for...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://mail.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the...

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

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 Access Date - exclude files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...

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

SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 TOP 100 is what improved our performance. -- If you can't find the person in your database in the top 100 of your search -- then you must be limited on what you know about this person... Refine your search. -- This "where" clause returns zero rows if...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 check the site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the AYAH dashboard should be "test.mycompany.com" and not "www.mycompany.com") STEP #2: Download AYAH files...

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

SSRS Stop Scrolling Behindhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 within a tablix (contains row groups, no column groups). The headers do not stay fixed at the top of the page anymore but then this isn't the show-stopper; being unable to see the bottom of the report was.

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 is easily automated and no longer blocks spam comments. Google's ReCaptcha is overrun by click farms and is unable to authenticate engaging visitors. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy...

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

Convert to Proper Case in T-SQLhttp://mail.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS ADDED TO REGEXP (eg. apostrophe) WHILE (@i 0 BEGIN -- get the delimited...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 This did not exist in my data flow ssis toolbox - if you do not see it when you are under the "Control Flow" design tab, then select Tools > Choose Toolbox Items > SSIS Control Flow Items > Tick the "For Each Loop Container") Add the Data-Flow to the...

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

AHK Countdown Tooltiphttp://mail.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ; set up array of jokes Joke1:="I pretend to work here, work pretends to pay me." Joke2:="He sets low personal standards and then consistently fails to achieve them." Joke3:="If he were any more stupid, he'd have to be watered twice a week." Joke4:="He...

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

Add attribute xsl:nil=true on empty elements using XSLThttp://mail.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 length of greater than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be emulated by the XSLT choose...when...test...otherwise: true true -- yields: assuming value of...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Submit form as a server and not the client with cURLhttp://mail.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 API. The third-party only accepts requests from a static and permitted IP address. If the end-user were to make the request, then their own IP address would be the one checked against, and it just wouldn't be manageable to add every new user's IP...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Search Module (JSM)http://mail.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 page. There should be several additional options to your search that will be displayed under the "Search Only:" heading and then a list of components. Find the value of the checkbox by viewing the HTML source and you should see something like the...

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

Warning: Save failed. Another menu item has the same aliashttp://mail.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 describing the company that we would want entitled "about" or "about-us" but these were already created along the way and then deleted. The system is still storing the offending menu items somewhere. How? The fix that I use involves a change to #__menu...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 The data still hasn't been properly decoded from UTF-16 and encoded to UTF-8 Test writing to a file, re-encoding the file then reading from it. Helpful Links XML parsing in PHP convert xml to json php curl utf16_decode PHP Manual: curl-setopt Well this...

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

List of Font Awesomehttp://mail.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 found at https://github.com/FortAwesome/Font-Awesome: OR add the linked stylesheet to the head section of your webpage You then add the icon to your webpage using a CSS reference: My facebook social icon Further examples are on the following site at...

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

Joes Quicklist Weblinks (JQW) Downloadshttp://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 v3 admin panel. - Date Uploaded: Mon, 14th Jul 2014 Download 3.1 AdrianaV/Vincent- Enhancement: Does not display more images then are available. - Enhancement: Auto-Check for cURL functions enabled on server. - Fixed Bug: cURL_Init uses encoded weblink...

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

Sort an associative array by values in Javascripthttp://mail.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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