Re: RecordSet fails if a field is null ! - unspecified error '80004005'

Tech-Archive recommends: Fix windows errors by optimizing your registry

Richard Mueller wrote:
Hi,

I cannot duplicate the error. However, if the value of the field is
missing, the array that is returned by the GetRows method has a value
that is Null. That is, the following statement raises a type mismatch
error:

Wscript.Echo aryRows(0, 0)

because aryRows(0, 0) is null.

Yeah. You have to do:

Wscript.Echo aryRows(0, 0) & ""


I do not get an error on either the
Open or the GetRows methods. However, if no rows in the table match
my query (the id doesn't exist), I get an error raised on the GetRows
method - "Either BOF or EOF is True, or the current record has been
deleted". The only time I get an error on the Open method is if the
syntax of the SQL query is bad.

Exactly. Which is why I asked him to verify which line was throwing the
error.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.