Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 on the web). In MySQL, I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of...

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

Difference between two dates - the midnight hourhttps://joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row as an example, the equation that's happening is: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession']));...

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

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take over the whole page if there were no modules positioned in the "right" div. I specified width of left using PHP. This is...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 in the folder for the weblinks have to be of the same file type (eg. BMP, JPG, PNG, GIF, or TIF). The program I had made to take the screenshots made them all the same type which is probably why I made the module think all thumbnails were equal. The...

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

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 - COM Tutorial by tank - Study the basics from this; I will not be covering them. - W3Schools - Many links listed below will take you to this website, which is an excellent resource for learning JavaScript in depth. Thank You: Chris Malet for creating...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 minor/major version number / Assign naming convention. --- Date Format for files (mysql format please cos unix will take my server's one). --- Enable Captcha to download? --- Specify News category (to tell everyone about your new projects) --- Specify...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 is @localvariable, Oracle is :localvariable). I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2 WHERE...

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

SSRS Zero Paddinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000"...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

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

21 August 2012 to type normally. Clear whatever you type so the field is empty and click somewhere on the page (not on a link as this will take you to another page) and the field returns to displaying "Name:". Why? I've noticed a lot of solutions now use JQuery or...

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

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

27 November 2012 (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place:...

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

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

03 April 2009 license for software and other kinds of works. The licenses for most software and other practical works are designed to take away your freedom to share and change the works. By contrast, the GNU General Public License is intended to guarantee your...

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

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

07 December 2012 If you want to reset the visitor count and associate it with just your site, you'll need to visit www.revolvermaps.com and take your ID from the script code: For example: rm_f1st('0','280','true','false','000000','3sv7MUqXeMI','true','ff0000'); or The...

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

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

05 February 2013 Export/Import happens under the Server Administration section: Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following...

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

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

14 March 2013 text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming EndDate is optional (can be null) and in format DDMMYYYY: -- Derived...

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

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

23 August 2013 shift patterns of an employee, you could enhance the above to skip day-off dates (eg. Saturday/Sunday - the above does not take this into account - my day-job company is a 24/7 business).

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 SDKs\Windows\v7.0A\bin\gacutil.exe Note: Currently SSIS/BIDS only supporting assemblies compiled with .Net 3.5 Take it to the GAC Run a command prompt as Administrator Change working directory to location of GACUtil CD C:\Program Files\Microsoft...

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

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

15 November 2013 is, of course, merely an initial draft of the agreement. Feel free to query, change and suggest other actions or route to take. My pricing structure: Easy, my base rate is £20/hour. I use my own timesheet system, so if you have a 5 minute job, this will...

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

Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 to Update the Joomla Core separately and prior to any 3rd-party extensions If you didn't have a backup, then I would simply take a Joomla install (preferably NOT the most recent version - so that you can force it to update later on) and copy over the...

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

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

03 November 2013 Wait for the restore to complete. The new phone will restart but you have to wait for the sync to start and complete (can take as long as the restore/backup) Done Unplug your new phone and test. Ta daa! If this article helped you, please leave a comment...

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