Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 Controls with JavaScript / COM This tutorial requires one of the following: AutoHotkey_L - has built-in COM Support (recommended) the COM Standard Library - for use with AHK Basic Purpose The purpose of this tutorial is to teach the intermediate AHK...

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

Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and stuff. Recommend to your bosses that you...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt Wolfe's video on how to do this: Youtube - Matt Wolfe - Install Stable Diffusion Locally....

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 of the record (sorted by ID ascending) and will attempt to delete the other records which match on product name. I would recommend commenting out the delete commands and leaving the info commands to preview what records it will delete. I also recommend...

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

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

04 February 2025 Joomla CMS from version 3 to version 5. Disclaimer: I'm used to doing this without any third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your files Why? I keep getting complaints that my server wants to...

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

Using K2 with jezReCaptcha plugin causing errorshttps://www.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 plugin options: Inclusion Syntax = NO Auto-verify =YES Update 16.NOV.2009 I don't see this supported anymore so I wouldn't recommend using the JezRecaptcha plugin. In fact I'm not impressed with Recaptcha as it's sound alternative doesn't work and the...

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

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

15 November 2009 you are going to edit the _buildQuery() function, search the file for the following comment and text. As always, I would recommend you make a copy of the file before making the change just in case you need to revert the change: // We need to get a list...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 wanted to change this to update every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything less than 4 hours worth, or your computer might get banned by the time servers. Change Your...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 I can do by setting up my work computer to be just like theirs (using the same image, etc). Programs which I would NOT recommend I've put a list of programs which I installed and uninstalled just as quickly as they failed to properly reflect IE6 and IE8...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 I spent a whole morning following someone else's complicated connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with!...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 version of the Joomla CMS! UPDATE 2012 - Valid for Joomla 2.5.x but only experimental for Joomla 3.0.x! I still do not recommend using this for your site if you have no test environment, however... I have used this script continuously to migrate J1.5.x...

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 called domain.com and you want to recieve mail on user@domain.com, you must *not* set your hostname to domain.com. We recommend using server.domain.com instead. You must make sure that you add the A record for server.domain.com so that it resolves. 2)...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 OR student_accounts.student_id=@SearchWord) Sorry only a workaround at the moment! I don't think I can recommend Microsoft's SQL Server Reporting Services as a replacement for website applications. We only did it because we have more staff trained in...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want it sorted in descending order, I would recommend you return it in SQL date format (yyyy-mm-dd) and then do "Sort Z to A". You may find that the field needs to be...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 to display an image or not. Bit of a cop-out I know but after two weeks of trying to find a solution, I would definitely recommend seeing if you can't check at the database level first. I will in future. Debug Method Fallback to debug methods; create a...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as I have not tested the performance and database load. Before: StudentID StudentName...

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

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 need a hierarchical authorization workflow process (in other words, you don't have a boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on the MySQL Forums. Someone solved their issue by resetting (or...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI Phantom and the Hubsan X4 H107C This model...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 type: GET connection: "joelconnector" ]; Additional I'd always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of debugging/testing when you can't seem to access that bit of...

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