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: *

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

13 December 2012 What? In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

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

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

19 December 2012 What? More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 What? So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability,...

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

Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 What? So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational...

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

Three boxes, two roll over, one falls outhttps://joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 What? So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width....

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

Set up Desktop SlideShow in Windows 7https://joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 What? Applies to Windows 7. Requires a Vogonian environment of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to...

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

Proposed Budget i3 PC under £200https://joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 i3 workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 ->set(array($db->quoteName('name') . '=\'Joël\'', $db->quoteName('username') . '=\'joel.lipman\'')) ->where(array($db->quoteName('user_id') . '=42')); $db->setQuery($query); $result = $db->query(); INSERT using JDatabaseDriver Here's an alternative...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added...

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

Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 Some memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [,...

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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using...

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

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

03 February 2013 What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to...

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

Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is...

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

Preg_Replace all strings between two tagshttps://joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 What? For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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

25 February 2013 Applies to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio...

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