T-SQL DateTimestampshttp://mail.joellipman.com/articles/database/t-sql/t-sql-datetimestamps.html

23 March 2011 I originally got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).

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

CSS Background Without Causing Scrollbarshttp://mail.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 to the top right: Tried and failed: Specifying the width of the div layer the same as the image and positioning the div. This causes a scrollbar at the bottom. Tried different techniques of CSS overflow auto hidden etc. all to no avail. What I didn't...

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

List all cron jobs for all usershttp://mail.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab file and cron job directory....

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

Run commands for Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 This is an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz...

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

Unix Date Format Specifiershttp://mail.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon...

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

Search a database for a string (MySQL, T-SQL)http://mail.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 query to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute...

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

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

27 November 2012 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: The empty arrow next...

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

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

11 February 2011 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, there...

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

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

26 January 2013 (exc. VAT) £14.99 (inc. VAT) Total £122.44 (exc. VAT) £146.93 (inc. VAT) Prices do not include the Operating System (in this case Microsoft Windows 7 Pro 32-bit) nor the chassis as we merely transferred the license from our previous machines.

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

Change the default Joomla Error templatehttp://mail.joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

04 April 2013 This is a quick article on what I change the error page for Joomla websites to. I like a clean error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, 2.5.x How? Backup the file \templates\system\error.php...

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

Problem creating SSRS report subscriptionshttp://mail.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 no longer valid. Why? The problem happens because of the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How?...

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

Copy a Wordpress Site for Developmenthttp://mail.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 are sample values and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'my_database_name'); /** MySQL...

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

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

13 March 2015 value. Change the item you created in step #2 (eg. "about_new" to "about-us"), also change the "path" value to match as this will generate your URL. Done

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

Sort an associative array by values in Javascripthttp://mail.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

Zoho Deluge - Modify the product line items in an invoice modulehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 This is a reminder on how to swap out a product in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the...

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

Advanced RokStories Stylinghttp://mail.joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

01 July 2009 RokStories has been overhauled to provide the spectacular display that you see on this demo. The module adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

404: Page Not Foundhttp://mail.joellipman.com/static-items/404.html

11 February 2015 not be found. It is possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will have been moved about but all the content that...

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

Zoho Deluge - Counting in a Map dataTypehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 Tuesday is if the last Tuesday of the month is before the current date, then set it to the last Tuesday of next month. Why? This was a request by a client who instead of specifying the 1st of every month, or 15th of each month, to say the first Monday...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 .toString() // What Creator understands: FAILS {"My_MultiPicklist":["Option1","Options 2"," 3"]} How? So the way to push this value over to Creator is by converting the list to a string... notably comma delimited: // Reading CRM: l_MyMultiPicklist =...

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