Add default to a picture buttonhttp://mail.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 Well there's a lot of autohotkey sites saying that you can apply a transparency and then capture special mouse events to emulate the mouseover and mouseout effects of a button with an image as a background. I couldn't get any of these working and they...

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

Convert Decimal (Person Days) to Time in Excelhttp://mail.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 minutes or 26640 seconds). How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ----------...

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

SQL: Use CASE for Relevance columnhttp://mail.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN columnFullName LIKE @ThisSearch THEN 10 WHEN columnLastName LIKE @ThisSearch THEN 10 WHEN columnFullName LIKE...

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

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 (GDPR) went into effect across all European Union markets. We believe this presents a new opportunity for marketers to strengthen their brand loyalty by focusing on consumer privacy while delivering amazing experiences. Think of it as experiential...

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

Alternate row background colour in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 I have, you need to adjust how you get the values from your events database). First get the events from your database and then get the rooms: ), Events AS ( --Create some events to place on the calendar SELECT tt.[RoomId] Room, tt.[StartTime]...

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

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been...

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

How to Display Report Execution Time in SSRS (milliseconds)http://mail.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another dataset (using the same data source if you like): -- Oracle 10g: DataSet2 -- a quick dataset following the first...

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

The Mermaidhttp://mail.joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 boys were skipping up aloft, And the land lubbers lying down below, below, below, And the land lubbers lying down below. Then up spoke the Captain Of our gallant ship, And a fine old man was he. "I have married a wife in fair London town, But tonight...

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

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

21 August 2012 What to do when the user moves their cursor into the field or clicks on it. In this specific case, if the value is "Name:", then clear the field and change the color to black (so when they type they can see what they're typing). onBlur() - happens when...

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

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

27 January 2013 "username" Multiple Row Results - loadRowList() This type of query is for when you want a cycle through a list of rows and then retrieve the values each row holds. $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select(array('name',...

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

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

14 March 2013 the date, month and year. How? I used two "Derived Column" tasks for this after giving up with a "Data Conversion" task. I then parse the date, month and year out using SUBSTRING: -- Assuming [This_Date]="21/03/2012" (DT_DATE)(This_Date) -- Assuming...

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

Things to Check if Joomla Password Reminder email not being senthttp://mail.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 Admin Panel Navigate to Global Configuration > Site > Site Settings > Feed Email = Site Email (check this is “Site Email”) Then go under Global Configuration > Server > Mail Settings > From email (has to be the exact sender email address (check...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 component. Example #1: As an SSIS Script Task My solution so far: The following script will convert to lowercase and then capitalize the first letter in addition to the above specification. I am storing it here so that I can work on improving it: /*...

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

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 Start "Android Studio" Go to File and create a New Project... I'm developing on a Tablet so I select Phone and Tablet then a relatively old version of the Android OS: Add an activity to Mobile: select Google Maps Activity: Change the Title to what you...

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

AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 ; Author: - ; Description: This program will remove the word EDIT and words containing an underscore (eg. 01_23) ; and then add an increment to the file name if a file with the same name exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date...

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

Zoho Deluge: Search Records with Special Characters (COQL)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 level domain (TLD) and will be either .COM, .EU or as per your region. If the first part of your URL says: https://zoho.com/ then use the endpoint https://www.zohoapis.com/crm/v2/coql https://zoho.eu/ then use the endpoint...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 > Developer Space > functions. Create a standalone function called "Test". Type in line 1: r_Record = zoho.crm.getRecords then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT - USE...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 for the rest of these steps. Once we have an access token, we will check what notifications already exist (if any), and then we will create a function that subscribes the application so that any order is sent to a URL, specifically a CRM REST API...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 a way to upload my image directly to Shopify in 3024x3024 resolution (or the size that the client wants: iPhone res). I then found that Shopify does accept a Base64Encoded version of the image and the below is how I achieved this. How? First-off, let me...

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