Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 a custom script component for SSIS. How? You can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 understand the carriage return and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using carriage return in column names New line Character in column alias

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 this latest app "byeBU" and this is version 0.4 Beta (unofficial app). Why? Something to do... How? The following code is using AutoHotkey (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they work for the same...

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

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

17 September 2014 of about 3 people high and stood so I could see the height of our 1 marshall's head. To be honest, the reason I wasn't using my propeller guards was that I clean forgot which was rather reckless of me, but the winds were really strong, I'd doubled the...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available to the user and for it to replace a displayed image in an...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 to: Android Studio (Beta) 0.8.9 Android Google Maps v2 What? A sequel to my article "Basic Android App using Google Maps and Current Location", this article suggests how to add Map as a sub activity. Note that this article is based on a new blank...

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

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 in the database for that website. The example used here will be to create an about-us page but I already have two items using the alias "about" and "about-us": Login to the Joomla Admin Panel and ensure any similar menu items are accounted for. Remove...

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

Joes Google Map for Joomla (JGM)https://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 but thought making my own to do exactly what I want was quicker. Script Function This displays a google map in a module using the Google Maps API v3 styling features which includes Points of Interest (POI). Considering I spent a good month styling...

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

List of Font Awesomehttps://www.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 OR add the linked stylesheet to the head section of your webpage You then add the icon to your webpage using a CSS reference: My facebook social icon Further examples are on the following site at https://fortawesome.github.io/Font-Awesome/examples/. The...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Joomla Admin Panel option: Cache-mode - Date Uploaded: Mon, 20th Sep 2010 1.0.0- Created according to brief (automated, using most frequent words) - Added Joomla Admin Panel option: Scan Joomla! articles - Added Joomla Admin Panel option: Scan K2...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 - Enhancement: Date is now "created" date. - Enhancement: Included span tags for individual elements. - Enhancement: Using div layers instead of tables. - Fixed Bug: Switched CSS ID tag to CLASS for W3C Validation. - Fixed Bug: Now allows description...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 for me on Joomla websites in general and prevents the administrator URL showing up at all in the stats (unless you were using it). Leaving this unchecked means that the crackers/hackers will get through ultimately whether it be by brute-force, DoS,...

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

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 to the Apimo WebService. The Apimo Webservice is an API provided by apimo.com and requires a server request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 to: Windows Live Mail 2012 What? A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 MIME Multipart/Related Content-type Google Drive API v3 | Files Update JoelLipman.com - Google Authentication - OAuth 2.0 using PHP/cURL

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 prompted for the number of rows per sheet (eg. 3000). In my example, this will produce an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 and have an image which covers them both... Which is an unintended but desired effect. Class .page: I actually like using this class because it's pretty descriptive. Unfortunately setting the width/height in cm was causing havoc to my template....

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 the mouse over the "Lanterns" link: » Home / Products / More Lanterns How? Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 ... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];... Lastly, there is a function I find myself using more and more called equalsIgnoreCase() which could be used:... l_ProductDetails =...

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