Inline Labels in Form Fields using Javascripthttps://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/SQLhttps://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 buttonhttps://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 linehttps://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 windowhttps://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)https://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

T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example...

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

RocketTheme's Affinity July 2009 Releasedhttps://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 Stylinghttps://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 Kunenahttps://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: *

Thank You!https://joellipman.com/static-items/thank-you.html

31 May 2009 Your feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 What? I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my...

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

Adding a selectable background to a Yootheme templatehttps://joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 Applies to: Joomla 2.5.8 Yootheme Template 2012 What? For any web-developer who can program in PHP/HTML, this would be easy to hard-code and override. However, the article below demonstrates how to make this an option that your client can switch off/on...

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

Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 What? This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the contents background (white) shows. When I visit a very long...

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

Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year...

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

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

27 November 2012 Event 1 A friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 GNU GENERAL PUBLIC LICENSE Version 3, 29 June 2007 Copyright © 2007 Free Software Foundation, Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The GNU General Public...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

DataTumble - Randomize Data Rowshttps://joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 What? This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3...

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

DataScramble - Randomizing data rowshttps://joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble...

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

Joes Revolver Map (JRM)https://joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 Instructions: Visit the website http://revolvermaps.com/?target=setup Configure the map to the settings you want. Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will...

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