Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $00000188 Const WS_EX_LAYERED = $00080000 ;#End Region ;#Region ShowWindow Styles Const SW_HIDE = 0 Const SW_SHOWNORMAL = 1 Const SW_NORMAL = 1 Const SW_SHOWMINIMIZED = 2 Const SW_SHOWMAXIMIZED = 3 Const SW_MAXIMIZE = 3 Const SW_SHOWNOACTIVATE = 4...

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

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions. The current...

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

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

03 November 2014 } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress // valid email address textPersonName // name of a...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to normal Joomla Articles SELECT new.`id`, old.`id`, json_extract(old.`attribs`, '$.spfeatured_image') AS `image_src`,...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow on save of the record, but the client wants the email to be prefilled in the field as soon as a contact is...

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

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 press Ctrl and scroll your mousewheel down. Makes everything on the page smaller. Ctrl+0 Returns everything on the page to normal size. Space bar Scrolls down the web page. Home Goes to the top of the page. End Goes to the bottom of the page. Press...

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 to the Internet (accesses http://news.google.com/) Checks you are a local administrator on your computer (should just need normal user credentials but if you get prompted to run the program as a different user and can't run the program this may be why)...

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

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

03 July 2011 has been modified to accommodate any Joomla! group (specified in the parameters). It is NOT RECOMMENDED to set this to normal users as this will use up your entitlement to FREE prints extremely quickly. The "STOP Thumbnail Service" parameter was created...

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

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 I wanted an empty row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling and room booking system). But I do...

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

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

17 November 2011 for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS...

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

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 No rows are returned for the first query and a zero isn't inserted. Note: Running just one of the queries will work as normal with the NVL function. Running the second based on the first will error this procedure. One Issue I just kept getting this...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

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

03 April 2009 The “System Libraries” of an executable work include anything, other than the work as a whole, that (a) is included in the normal form of packaging a Major Component, but which is not part of that Major Component, and (b) serves only to enable use of...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• 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 all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 Date - exclude files used since n. (If n...

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

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

10 October 2014 Location myLocation = locationManager.getLastKnownLocation(provider); // set map type mMap.setMapType(GoogleMap.MAP_TYPE_NORMAL); // Get latitude of the current location double latitude = myLocation.getLatitude(); // Get longitude of the current...

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

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

22 February 2019 be something like img src="https://crm.zoho.com/viewInLineImage?fileContent=: You should find your code now previews at a normal font size. Step #2 Create your template without uploading images and style with your CSS. Step #3 Resize the images with a...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal week (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { //...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 = " Error: " + errorOutput + " "; document.writeln(parsedOutput); } else { // If parsedOutput is an object, you can now use normal dot notation: if (parsedOutput && typeof parsedOutput === "object") { // If the output is an object, you can access its...

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

Ubuntu as a media serverhttps://joellipman.com/articles/linux/ubuntu-as-a-media-server.html

19 September 2009 is never cropped off, but when the user switches back to Ubuntu's gnome desktop, the top nav bar is cut off if he's using a normal tv and not a pc monitor. I'd like to have 1 screen adjustment tool that correctly adjusts both the lmce desktop and the...

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