OT: ASP Classic Datasets And Null Columns

[Jumping Matt Flash]

Apologies that this is an ASP 2.0 Question instead of .NET but i couldn't
find a more appropriate news group.

I'm trying to deal with values in my dataset which are set to null.
Using VBScript, i've tried the following but I get an exception thrown:

72: If objRecordSet("AccountNumber") <> ""
73: Then Response.Write "" & objRecordSet("AccountNumber") & ""
74: Else Response.Write " "
75: End If

Error Type:
(0x80020009)
Exception occurred.
/hewden/XXXX.asp, line 72

Or if i try the following an exception is also thrown
72: If objRecordSet("AccountNumber") Is Nothing
73: Then Response.Write " "
74: Else Response.Write "" & objRecordSet("AccountNumber") & ""
75: End If

Error Type:
(0x80020009)
Exception occurred.
/hewden/XXXX.asp, line 74

Any ideas?

TIA
Matt

 

[Juan T. Llibre]

microsoft.public.inetserver.asp.general
is the ASP 1.0/2.0/3.0 newsgroup.




Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================