Search this site:


Categories:

September 12, 2003 11:28 PM

Broken: Store hours

Andrew Rollason writes from London:

I was just about to pick up some groceries from the Marks and Spencer store down the street.

The website has a decent online store finder, but unfortunately their opening hours are shown as a decimal.

Comments:

The correct link is:

http://www2.marksandspencer.com/stores/details.asp?store=248&scale=0&week=32&hourstype=2

This happens with the time-datatype fields in some databases. They are stored as floating point numbers, so if you don't correctly translate them, you get amusing results like this. =)

Posted by: Josef at November 6, 2003 03:06 PM

Well it's better than what I'm getting on that site:-

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CInt'

/stores/inc/store.class.asp, line 64

Posted by: LordRich at April 22, 2004 05:17 PM

LordRich is right.

Posted by: Ilaan at September 27, 2004 08:30 AM

That VBscript runtime error is embedded in the code of the page.

Microsoft VBScript runtime error '800a000d'

I think it means your browser doesn't support Visual Basic (mine doesn't and I get the same error). You sort of have to wonder why they don't replace '800a000d' with something like

'this page only works in IE 4.0 or later in Microslosht Windows'. Probably a good technical reason... no clue what. The link posted above by Jouet seems to be the javascript version and should work everywhere (including IE in windows).

Posted by: billc at December 14, 2004 04:40 PM

Hit refresh and the page should come up.

Posted by: Wootables at March 14, 2006 12:58 PM

The problem with the first link is the embeded br tag in the middle of it.

Posted by: ? at March 16, 2006 01:51 PM

Comments on this entry are closed



Previous Posts: