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

03 July 2011 > "Module Manager" > Click on module to publish/customize it. Specify the images folder as the one you created in step 2. Switch "STOP Thumbnail Service" to "NO" Specify a group which can generate thumbnails and use the service. Login to front-end as a...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This is written at a time when Javascript or interactive pages that...

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and...

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

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

27 September 2019 we want the last Tuesday of the next month. In the following code, consider that the date field we want to set is called "Switch_Over_Day". For the first Monday, we are going to select the first day of the month and then loop until we find a Monday....

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 - number of times that weblink has been visited state - this is the J16 published/unpublished status ordering featured To switch the default ordering (ascending / descending), change the ASC to DESC on line 187: $listOrder =...

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

Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 same error. He (unless Andy is a girls name) posted to a forum which was even more useless asking him about a write-protect switch (physical). The user then said nevermind and found the answer himself. The discussion is on the page...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 automatically expire? Reminder on Paper Sizes A4 = 8.27in (width) × 11.69in (height) Letter = 8.5in (width) x 11in (height) Switch width's for height to convert these to landscape.

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

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

23 March 2011 height). This way when it's printed out (backgrounds won't print by default) the occupied blocks will show up. =Switch(Fields!Status.Value="", "#ffffff", Fields!Status.Value="2", "firebrick", Fields!Status.Value="-1", "#999999") One I did earlier:...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 stopped working, in fact it hasn't been working for ages, could you also look at that". "Is there a power light on when you switch it on?". "Yes it's definitely plugged in if that's what you're asking.". "Is it a networked printer, I mean is there a...

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

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

28 June 2011 exist (cwebpage.dll and gdiplus.dll). Website Errors Be on the lookout of websites that generate popup script alerts (just switch these off in MS Internet Explorer - Internet Options - Advanced - Untick "display notification of each error") as these may...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 want to filter the pivotTable data based on these two values... (I don't like the idea of requiring macros as not all users switch this on and teaching executives on how to do this is tough work. What Next? Permissions on EXCEL filters: Need to control...

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

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 be easy to hard-code and override. However, the article below demonstrates how to make this an option that your client can switch off/on using the Joomla Admin Panel. How? For demo purposes, I'm going to add the background "Ambient Turquoise". Yootheme...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content....

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 » [Same file again] \plugins\search\content\content.php: Add the option to select by relevance to the CASE order statement: switch ($ordering) { // BEGIN: joes new ordering option case 'relevance': $order = 'relevance DESC'; break; // END: joes new...

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

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

23 February 2014 Symbolic Link itself versus the target of the link. /J Copies using unbuffered I/O. Recommended for very large files. The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line. Other Sources:...

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

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

07 September 2015 Added parameter: Display category. - Enhancement: Reorganized parameters "Module Settings". - Enhancement: Parameters switched from radio to list type. - Enhancement: Aesthetic tweaks for Joomla v3 admin panel. - Date Uploaded: Mon, 14th Jul 2014...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 and 3 desktops. I'm going to cover the basic code to: 1) get all monitors, 2) open an app on a specified monitor, 3) switch to another desktop. Count Monitors and Check it can see left-most, central, and right-most monitors: ; init DetectHiddenWindows,...

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

Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 obtained from a CRM field and compare it to the current time combined with a timezone. In this particular case, we will switch the current time to Europe/London (You can use an abbreviation such as GMT but this doesn't seem to check if daylight savings...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 if(zoho.currenttime > input.DateTime_form_was_loaded.addSeconds(10)) { // do my stuff here } Method #2: Boolean checkbox to switch on/off workflow Another method I tried was adding a checkbox/decision box (boolean) to the form called "Update_Preview"....

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