Source: http://en.wikipedia.org/wiki/Comparison_of_web_browsers

Intro

I know there are a lot of articles on the WWW detailing this process but none of them really worked for me.  I recently changed job and no longer have all my test machines at work.  Instead I only have the one workstation :eek  Still I've been asked to test some web applications (???) so I had to find a solution to suit me.  I'd done this before IE7 (so a long time since).

My office workstation setup for this is:

• HP CMT DC7900
• E5300 @ 2.60Ghz
• 2Gb RAM
• Windows XP Professional SP2 
• Internet Explorer 7

As you can tell, not the most up-to-date but unfortunately I need to stay near to my customer base and match their setups as closely as possible.

Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine.  Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy).

• SQL Server 2008
• Report Builder 2.0
• BMC Service Desk Express 9.8

• Incident #
• Group Name
• Close Date & Time
• Assigned to Full Name
• Incident Type

Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly.  Anyway here's just a quick note on how to do if else statements in Report Builder 2.0

I'm looking at the following if statement:

If (MyFieldName = 0) Then
     Return 1
Else
     Return MyFieldName

Can be expressed as:

IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)

The Issue

After modifying a report and on running it, Report Builder 2.0 returns the following error:

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset 'DataSet1'.
The variable name '@GroupName' has already been declared.  Variable names must be unique within a query batch or stored procedure.

Just a quick note for the moment on how to use ternary operators in AutoHotkey.  A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages.

For Example, the statement:

If (ThisCondition = true)
    ThisVar:=1
Else
    ThisVar:=2

Converted to Ternary this would look like:

ThisVar:=(ThisCondition = true) ? 1 : 2

Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants).

Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough to run these effects without affecting performance.

If this is happening to you, and you don’t mind about a possible slight slow down on performance you can force enable them -

1. Go to Control Panel -> System and Security -> System
2. Click on advanced system settings on the left and then performance settings.
3. Under the visual effects tab you should see that the option “ Let windows choose what’s best for my computer “ is by default checked.
4. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features.
5. Select the custom option and then select all the effects from the list below it. Hit apply and ok and you should have all the Aero effects enabled.

Now what are these Aero effects?

1. The concept - typically drawings, words, models, code and basic prototypes that describe the nature, objectives and features of the website.
2. Design document - a detailed plan of the website’s features and how it will display are generated from the concept and presented to potential publishers.
3. Technology demo – a prototype that demonstrates the website’s technology, illustrating for example the presentation and registration services. This is produced for review so as to decide if concept is marketable.
4. Browsable prototype or Vertical slice – normally a few sections of the website are produced with many of the website features in and working, this allows reviewers to get a feel for the site, the level of usability, the saleability of the product and technical risk involved in fully developing the website.
5. ALPHA/BETA – these are the next major milestones that represent near completed websites, these are subject to extensive testing, compatibility and QA by both the developer and the publisher.
6. Master – a completed, bug-free website approved by the customer and available online.

Typing an ASCII character

In DOS:

Hold down the <Alt> key while typing the decimal number on the keyboard keypad. (Example:  <Alt>178)

 

In Windows for a DOS character:

Hold down <Alt> while typing the decimal on the keyboard keypad. (Example:  <Alt>230)

 

In Windows for a WIN character:

Hold down <Alt> while typing "0" then the decimal number on the keyboard keypad. (Example:  <Alt>0140)

I just had to put something here as I have been buying and returning failed/corrupt USB pens.  In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent.  I use my USB pen as the "My Documents" folder on every computer I use.  It was fine with my 16Gb one but my 32Gb ones have all failed at some point.

I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com (Leather 64Gb@£29.99).  In hindsight, the Ebay one was obviously going to fail (faking the disk size).

I got badgered by my colleagues to splash out and get a worthwhile pen.  Aside from some other failures, I decided to get the bulletproof, waterproof, fireproof, shockproof 32Gb USB Pretec Pen (as advertised by Gadget Show on Five.tv).  Turns out this is an incredibly fragile pen. If files are being written to it and it gets nudged, this will corrupt the pen.  BTW I don't use the "remove device safely" rubbish as my old pen never did and it was fine for over a year.  The default setup in windows XP is that it doesn't need it.

Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof! ...

So this is a comparison chart (at least in my opinion) of 3 major joomla template/extension providers.  When I'm less caught up in work I'll try adding to this article.  But here's some lazy stats: