No rows returned in Oracle causes SP to failhttp://mail.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/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 What? I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they...

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

MySQL: Display Users and Duration in Matrix Timesheethttp://mail.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 Thought I'd add the migration script I've been using to test my JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as...

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

Prefix Line Numbers in a Text Filehttp://mail.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

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

Print Directory Contents to a Filehttp://mail.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 Why? A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu...

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

The Mermaidhttp://mail.joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 'Twas a Friday morn when we set sail And our ship not far from land, We there did espy a fair pretty maid, With a comb and a glass in her hand, Her hand, her hand, With a comb and a glass in her hand. While the raging seas do roar, And the stormy winds...

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

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on...

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

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will...

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

Connect to Joomla database in standalone scripthttp://mail.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 APPLIES TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit...

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

Basic Joomla 2.5 Mootools Formhttp://mail.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 Joomla 1.6.x - 2.5.x: Out-of-the-box template: -- add subfolder if this is not in the root of the domain: -- eg. http://demo.joellipman.com/joomla25/ has file in -- -- also note that this form can work with simply the core mootools script -- but does...

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

Inline Labels in Form Fields using Javascripthttp://mail.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 What? This is to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears,...

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

Data Randomization Function in Oracle PL/SQLhttp://mail.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 What? This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of...

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

Joomla article modal with clear buttonhttp://mail.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 Applies to Joomla 1.6+ What? This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted...

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

Vertically align an asterisk on a linehttp://mail.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 What? So I have an unordered list of values (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Slideshow div layer through a windowhttp://mail.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 {duration: 1000,transition: Fx.Transitions.Quart.easeOut}); $('slide_01').setStyle('background-image', 'url(http://www.joellipman.com/images/jcd/pea_green_bg.jpg)'); $('slide_01').setStyle('width', v_win_width); $('slide_01').setStyle('opacity', '1');...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Search a database for a string (MySQL, T-SQL)http://mail.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search...

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

RocketTheme's Affinity July 2009 Releasedhttp://mail.joellipman.com/articles/cms/joomla/rocketthemes-affinity-july-2009-released.html

01 July 2009 Affinity is the July 2009 release from RocketTheme and features extensive third party support for powerful and popular community products, such as JomSocial, K2 and phpBB3. The template's core feature is Sortable Elements, which allows for the movement...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

Advanced RokStories Stylinghttp://mail.joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

01 July 2009 RokStories has been overhauled to provide the spectacular display that you see on this demo. The module adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

Add a template to the dropdown in Kunenahttp://mail.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 This is what I had to do to be able to add another template to the dropdown in the Kunena configuration panel: Download your site from your server to a copy on your local disk (hard disk, flash drive, etc) Make sure that the...

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