Re: RecordSet fails if a field is null ! - unspecified error '80004005'
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Wed, 31 May 2006 19:02:23 -0400
Dan wrote:
Bob Barrows [MVP] wrote:
Troubled User wrote:
Heres a good one.
I have my ado stuff in a class, so that I don't have to deal with it
in my code.
In the class.FetchRows function I do the following
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open strSQLStatement, DBConn
aryRows = rs.GetRows()
This statement will raise an error if rs.eof is true. Always test
for eof before using GetRows or GetString:
if not rs.eof then aryRows = rs.GetRows()
For this case i dont think that bof/eof is the problem.
:-)
I didn't say it was, did I? I was just covering all the bases. When I see
sombody doing something that may cause them problems in the future, I like
to point that out. It's called "being helpful".
If i copy and
paste the same string into ms Access It returns the row that I
expected. Also, If i simple change the field from origin to something
that i know has data in it, then i don't get this error message.
I didnt think that eof was a problem with get rows. I'll assume that
you know more then me about that then I do, so ill just add that in
anyway.'
Well, if you're going to get snotty about it ...
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Follow-Ups:
- Re: RecordSet fails if a field is null ! - unspecified error '80004005'
- From: Troubled User
- Re: RecordSet fails if a field is null ! - unspecified error '80004005'
- References:
- Prev by Date: Re: RecordSet fails if a field is null ! - unspecified error '80004005'
- Next by Date: Transfer values from one form to the other
- Previous by thread: Re: RecordSet fails if a field is null ! - unspecified error '80004005'
- Next by thread: Re: RecordSet fails if a field is null ! - unspecified error '80004005'
- Index(es):
Relevant Pages
|
