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

21 January 2013 and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel left over, more the fact that the scripts use that 1 pixel (ceiling rather than floor?). Why? We have a row on a website of three boxes made of...

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

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

22 January 2013 for every change. About a zillion group policies control our every deviation from the standard staff image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want to change their desktop background...

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

Restore MSSQL Error: Database is in usehttp://mail.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant...

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

Country Lookup by IP address CSVhttp://mail.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 suggestions? We are looking to add the ability to generate this data using other sources and in time a region by IP for more accuracy. Feel free to feedback. It's FREE to download unlike others which is probably why I made the generator in the first...

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

Joes Syntax Styler (JSS)http://mail.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 initially built for someone as a quick syntax highlighter that recognizes SQL; but I am working on getting it to recognize more programming languages so that I can use it on my own site. Limitations Recognizes SQL only Proposed Enhancements: Recognize...

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

MS Excel - Sort pivottable column headings by datehttp://mail.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think...

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

Autohotkey Count Number of Files/Folders in a Directoryhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing (or whatever your script is trying to do). Method #2:...

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

Reorder Columns in a Tablehttp://mail.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column BIT(1) NOT NULL DEFAULT b'0' AFTER other_column; -- OR A MORE COMPLETE EXAMPLE -- ALTER TABLE table_name MODIFY COLUMN misplaced_column VARCHAR(13) NOT NULL DEFAULT 'DefaultString'...

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

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

23 August 2013 1.00 002 3.00 2000-02-18 1.00 002 3.00 2000-02-18 1.00 003 2.00 1999-02-25 1.00 003 2.00 1999-02-25 1.00 If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the...

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

htaccess Rewrites SEF URL and submits to PHPhttp://mail.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 [NC] But, er, I like that first check (myFolder) that the submitted URL matches the format of your site (and a lot more opportunity to check for malicious code).

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Compare two databases using T-SQLhttp://mail.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first database name and "myDB2"...

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

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

04 October 2013 can change just this script instead of the ones for every package). Here is the near enough final version of my script (or more like an experienced colleague's comprehensive script to which I have merely added my transform part) added as a data flow...

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

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

15 November 2013 Additional I am a one-man band, a solopreneur, freelancer but I specialise in automation which lets me do the work of many more. I have associates who can step in when necessary but they will not necessarily match my skillset. My associates only get...

• 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 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 find the following 3...

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

Export Joomla Users scripthttp://mail.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 so will have to watch those landings and thats with thicker than stock pads Done. Here's a video and I will try to post some more: {youtube}tG6Yg0H11U8{/youtube} Noticed a problem with jello. This problem was due to the new propellers I was trying (9"...

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

DJI Phantom FC40 - Fun at the raceshttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 more distractions. This is my filming of some Radio Controlled cars at the Torch Racing, UK event last Sunday. The FPV latency isn't good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I...

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

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 = CameraUpdateFactory.newLatLngZoom(myCoordinates, 12); mMap.animateCamera(yourLocation); Additional Additional: A little more control on the animation? CameraPosition cameraPosition = new CameraPosition.Builder() .target(myCoordinates) // Sets the...

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

Android: Replace return key with done, go, send...http://mail.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 IME_ACTION(s) IME_ACTION_DONE // the action key performs a "done" operation, typically meaning there is nothing more to input and the IME will be closed. IME_ACTION_GO // the action key performs a "go" operation to take the user to the target of the...

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