Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 the flamer (which also counts as flaming). No Profanity or Obscene Content - Such content does not belong on TEU. A censor system is in place as a backup. If you see words in your post being replaced with ****, you have done something wrong. Please edit...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 } PrevControl := CurrControl If (CurrControl="SearchButton") { GuiControl,, SearchButton, %SearchButton_Over% SetSystemCursor("IDC_HAND") } } return DisplayToolTip: SetTimer, DisplayToolTip, Off ToolTip % %CurrControl%_TT ; The leading percent sign tell...

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

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 PC 2007 SP1 (http://www.microsoft.com/downloads/details.aspx?FamilyId=28C97D22-6EB8-4A09-A7F7-F6C7A1F000B5&displaylang=en). System Requirements: Virtual PC 2007 requires a 400 MHz Pentium-compatible processor (1.0 GHz or faster recommended), and...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 that claims to be from «CompanyName», eBay, PayPal or another company and offers buyer protection or an online payment system. This could be directly in connection with a transaction through someone you’ve met online. Or perhaps the buyer or seller...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Connectors from dev.MySQL.com .NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Manufacturer: Microsoft Bridging to MySQL OLEDB This is just one connection string sample for the...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like. I like queries...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below the details, we've connected it to the assets database and want to list the equipment and features found inside the...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 to do this? Same errors on another computer? What are your workarounds? Protocol for Troubleshooting: Check system properties for RAM and CPU speeds Reduce visual effects for increased performance during troubleshooting Note background and visual...

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

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

28 June 2011 Tested on: Windows XP SP3, Windows 7 (both 32-bit) Tested with: MS Internet Explorer 7 libraries System Requirements: Used ~55Mb RAM on 1.6Ghz PC Free Disk space to store your pictures Installed MS Internet Explorer (only uses libraries) Program Size:...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 like remository and lacked the features I needed. There were also standard features I wanted that didn't exist in the other systems. I wanted minimal code and leave the comments/videos/pdf to be handled by existing Joomla! CMS features. I also needed a...

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

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

19 September 2011 to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 "Command prompt from here" option (now built-in to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry (see "How: for Windows 7" below). -- yield a_subfolder_in_this_folder a_file_in_this_folder.txt...

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

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

01 August 2012 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 DateOfBirth -----------...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 ( SELECT '[' + SC.name + ']' + ' LIKE ''' + @SearchStr + ''' OR ' + CHAR(10) FROM SYS.columns SC JOIN SYS.types STy ON STy.system_type_id = SC.system_type_id AND STy.user_type_id =SC.user_type_id WHERE STY.name in ('varchar','char','nvarchar','nchar')...

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

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

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

Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause...

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

Proposed Budget i3 PC under £200https://www.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 but in the meantime we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core CPU ( 3.30GHz, Socket 1155, 3MB Cache, Ivy...

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

Change the default Joomla Error templatehttps://www.joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

04 April 2013 a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, 2.5.x How? Backup the file \templates\system\error.php Create a replacement file called error.php including the below code Change the message "The Page you are looking...

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

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

07 May 2013 the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line with other search systems....

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