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

05 July 2011 Tutorial on how to use COM objects in AutoHotkey. Source: Jethrow @ Autohotkey Forums Basic Webpage Controls with JavaScript / COM This tutorial requires one of the following: AutoHotkey_L - has built-in COM Support (recommended) the COM Standard...

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

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 reports as subreports - toggle visibilty based on parameter. Method #2 Add a button below "View Report" linked to some script code (requires change to ASP pages on the ReportingServer, ie. affects all reports on that server). Method #3 Use ASP instead...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were trying to...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 ** Author: Joel Lipman ** ** Created On: 12 October 2012 ** ** Revision: v1.2 ** ** Description: Script to create a SQL query which searches a database with SOUNDEX (detects typos). ** ** ** ** Usage: ** ** Step #1: EXEC...

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

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

07 December 2012 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 DateOfBirth -----------...

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

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 the visitor count and associate it with just your site, you'll need to visit www.revolvermaps.com and take your ID from the script code: For example: rm_f1st('0','280','true','false','000000','3sv7MUqXeMI','true','ff0000'); or The Unique ID code would...

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

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 to Windows 7, Windows Server 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, Specify the command path which is usually %windir%\System32\cmd.exe Add arguments in format /c start "Task Name" "Full Path...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 some benchmarking I won't know which ones best: Method #1 This method replicates the table in a listview format: ; tell the script which content to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character positions) Needle1a := " My...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 gives data as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract all data into a Comma Seperated Values (CSV)...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 AUTO_INCREMENT=1 ; Make sure you have the INSERT INTO commands if this includes website data!!! Drop the table Reload the script you just modified.

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

Joes Google Map for Joomla (JGM)https://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 used someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker. Script Function This displays a google map in a module using the Google Maps API v3 styling features which includes Points of Interest...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 errors or how to set up a basic ping request, I thought I'd write this article. How? Using PHP and cURL, here is the full script for a standard ping request. Before you say it doesn't work, it has to be updated every time a new schema is introduced to...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 Fri, 9th Jul 2010 1.0- Added GNU/GPL License information to xml/php - Behaves like custom module and inserts RevolverMaps script. - Date Uploaded: Fri, 2nd Jul 2010

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 (joomla 3.x) RewriteCond %{HTTP_COOKIE} !JoomlaAdminSession=1234567890 # change this to the code to match the above PHP script RewriteRule .* - [L,F] How-to-use: Browse to the folder you created in step 1 and this will be your new administrator URL....

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 js.id = id; js.src = "//connect.facebook.net/en_US/sdk.js"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk')); (function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js =...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 anyone to trust an executable EXE so here's the code of what it's doing which you can copy and paste to an AutoHotkey script: #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. #Warn ; Enable warnings to assist with...

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

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 and register your new app (or the one you will have completed once copying the below scripts). Let's start with the first PHP file which I will call functions.php. Note that you will need to edit the global vars to be used by the functions located at...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the...

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

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 JoomlaCMS or WordpressCMS It creates a unique name to use in URLs I want that Why? These are used as inputs to server-side scripts for the sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB