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

05 July 2011 CSIDL_INTERNET = $0001 Const CSIDL_PROGRAMS = $0002 Const CSIDL_CONTROLS = $0003 Const CSIDL_PRINTERS = $0004 Const CSIDL_PERSONAL = $0005 Const CSIDL_FAVORITES = $0006 Const CSIDL_STARTUP = $0007 Const CSIDL_RECENT = $0008 Const CSIDL_SENDTO = $0009...

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

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

08 October 2012 I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL...

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

Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 and then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're...

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

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 a part of a Password Security System I wrote back in 2008 and I missed the analysis capability so I have restored it on my personal website. Security through Obscurity "Security through Obscurity" is always ultimately fallible. This password checker can...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ; set up array of jokes Joke1:="I pretend to work here, work pretends to pay me." Joke2:="He sets low personal standards and then consistently fails to achieve them." Joke3:="If he were any more stupid, he'd have to be watered twice a week." Joke4:="He...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 Hide the first column in the list view (contains "Profile 1", "Profile 2",...) Sort the second column (contains "Joes Personal Profile", "Joes Work Profile", etc) Create subroutine for when listview row is double-clicked to open Chrome Browser with...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 a running White Snow Edition PC but I put in some more to get the Graphics Card, more RAM, more fans, more... What I had: Personal Home PC Work-from-Home PC Case Antec Fusion Black 430 Dell OptiPlex 9020 Micro Form Factor CPU i3 4th Gen i7 4th Gen RAM...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 from the above function to generate a HTML signature, then use placeholders for the code to replace these with the user's personal details (eg. name, job title, etc). /* *******************************************************************************...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 Account Data": I then click on the "image" sub tab and change the "Image Position" so that the image is under the text (personal preference here and completely optional): So now I can go back to my query and expand on it a little to include the other...

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

The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work...

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