Mouseover Links in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 this all about? Well I want the basic hover effect: when my mouse cursor hovers over a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How?...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 One called "strip_tags" crashed in the running of the query. The function that did work errored persistently complaining about the delimiter, create the function by running the following: SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF...

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

MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 -- 2012-04-27 -- this Friday -- 2012-05-04 -- next Friday -- 2012-05-04 -- next Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both...

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

VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values...

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