Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 and update this article. I found someone else on the Internet who doesn’t use the “remove device safely” blab and he got the same error. He (unless Andy is a girls name) posted to a forum which was even more useless asking him about a write-protect...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 Flip 3D This Aero effect was in Windows Vista but not in XP. Activate it by pressing the windows key () and tab () at the same time. It will give you a 3D effect that will allow you to “Flip” between the different windows. Keep holding the Microsoft...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• 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 their environment as accurately as I can which 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...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 in SQL Server Reporting Services and that all data types should be kept in their original state and then queried in the same state.

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 Issues encountered Note there appears to be an issue with regards to rendering. An updated and deployed report on the same day will render fine in a webbrowser but when exported to PDF format, it will retain the previously deployed report settings...

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

Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date...

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

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 want the clouds as another layer ontop aligned to the top right: Tried and failed: Specifying the width of the div layer the same as the image and positioning the div. This causes a scrollbar at the bottom. Tried different techniques of CSS overflow...

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

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

28 April 2011 need to do? Last time it worked? Emails received since? Programs installed since? Alternative documents/programs to do this? Same errors on another computer? What are your workarounds? Protocol for Troubleshooting: Check system properties for RAM and...

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

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

05 July 2011 with its 1st elements name being search_keywords. The following javascript fed throught the address bar would produce the same results: Code: javascript: alert(document.SearchForm.search_keywords.value) MsgBox %...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 the series field and [DayOfYearRun] will be category field: So is this doing what I wanted? Well NO. I have a table with the same report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 What's the problem? Enter this as a query in Excel without the parameters and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused. Putting it all together Create a SQL query that will return: staffname,...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 have an immediate undo process. The form page carries the cancel button (textbox which actions to the previous report with same parameters) and another link which leads to our report containing the call to the Stored Procedure. This page itself contains...

• 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 for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by...

• 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 SSRS) that the existence of a photo depended on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks of...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate)...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 data that this stored procedure commits but unfortunately SSRS process both the Stored Procedure and the SELECT at the same time; this meant the report would say the process failed but when I check the logs, it successfully ran the stored procedure...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 Post-Installation Go to JComments Settings and specify the same "Choose categories for JComments to work in" as you have for your 1.5 website. The above script ignores your previous settings and leaves the factory settings that come with the JComments...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 much just "...fast and works with cms articles...". If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *