already this week I have hit two more serious bugs in VBScript/ASP.
First the recordset implementation is seriously flawed - if you get the values of columns in a different order to that in which they were returned from the Database then you will get empty data once you have read the last column. Worse still sometimes you can't access the contents of a column once you've requested the value of a later column. This is so very broken I don't know how people can put up with it.
Second I got an error message at line 0 because of a syntax error at line 46. When you are debugging VBscript then the line number is critical due to the lack of helpful debugging information.
Half the reason I find it so unpleasent to develop in ASP is because it feels not only unfinished but also insists in the bondage / discipline of Java or C++ without the benefits of OO, strong Typing, References, etc.
More and more I am starting to believe that ASP is the choice of the rank amateur. I have never seen a single piece of ASP code that has made me think 'oh thats cool' let alone 'if only it was that easy in perl/c/brainfuck/assembler'. gah!
in case you are thinking 'just write less buggy code then you wont have to debug so much', its worth pointing out that with the bad practise and corner-cutting that is the norm with ASP developers most code-reuse is through cut and paste, no Inheritance or abstraction is available because VBScript OO is broken and the includes are quick hack that trample over namespace and scope.