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

20 August 2012 It may not be right, it may not be the best or optimized order but it works for me and that's pretty much all I needed. Change www.YourSite.com - Yeah note the URL to the mootools-core-uncompressed.js file, if you have this enabled in Joomla then you...

• 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 it. By increasing the size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would overlap the item beneath it (in...

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

Stored Procedure to List Distinct Values and Countshttp://mail.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 ** ** ****************************************************************************************************************** ** Change History: **...

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

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 the value in this table. ** ** ** ************************************************************************************ ** Change History: ** ************************************************************************************ ** Date: By: Rev: Desc: **...

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

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

07 December 2012 TOP (@random) ID FROM #Scramble WHERE Chosen IS NULL ) A IF @ChosenID IS NULL RAISERROR('There are no values left to change the Data',16,1) UPDATE #Scramble SET Chosen = 1 WHERE ID = @ChosenID SELECT @UpdateData = Data FROM #Scramble WHERE ID =...

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

Error 1065: Query was Emptyhttp://mail.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 (“\”) character. \% A “%” character. \_ A “_” character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES...

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

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 copy these to TEST using the web-based file manager. Above & Beyond Creating subdomains allows your developers to simply change the http://www.mysite.com to your development environments, eg. http://dev1.mysite.com, http://dev2.mysite.com,...

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

Quickly update all content in mySQL database replacing a stringhttp://mail.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; SELECT `id` , `title` , IF(LOCATE( @stringtoFind,...

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 the shortcut a name to display as (eg. "Visual Studio 2010") Click on OK to complete your shortcut. Additional: You can change the icon for the shortcut using the shortcut properties and browsing to the program it was created to run. Related Link(s):...

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

Setting a rocket theme background to fixedhttp://mail.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 Look in the CSS folder of the template. You should find a PHP file in this folder with the body.bgstyle# line you need to change as in steps 3 and 4.

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

Security Checklistshttp://mail.joellipman.com/articles/cms/joomla/security-checklists.html

06 September 2009 … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and directory permissions 5. Remove unneeded files 6....

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

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 Last Troubleshooting Check: The problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had been setting it to "fixed width" but then got problems with it not understanding the...

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

Parse a HTML Table into a ListViewhttp://mail.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 of code that replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1 This method replicates the table in...

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

T-SQL Conversion failed when converting the varchar to data type inthttp://mail.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT r1.MapIn ( SELECT...

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

Joomla Component: Set default params on installationhttp://mail.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following line to the XML installation file: script.php Now create a script.php file in the root...

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

Client Services: Website Development Agreementhttp://mail.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 my server to receive requests for those domains (along with webspace and emails). Please wait up to 3 hours for these changes to cascade across my servers (average wait is 1 hour). JoelLipman.Com will develop the startup site using an Agile framework...

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

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

24 November 2013 on registration form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and...

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

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 were new in the original folder and only copy those over (reason being, the archive is 4 terabytes and backing up only the changed files would speed things up). Applies to: Microsoft Windows XP Microsoft Windows 7 Microsoft Windows 8 for Vista and...

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

Prices get rounded up in Virtuemarthttp://mail.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 this was due to installing a Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to change the number_format to convert any number to a currency or two decimal places. Another suggestion was to alter the main...

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

301 Redirect using htaccess filehttp://mail.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain. Why? I...

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