[thelist] ASP, SQL, Recordsets, Best Practices

Michele Foster michele at wordpro.on.ca
Thu Mar 1 15:19:03 CST 2001


From: "Scott Dexter" <sgd at ti3.com>

> <%
> Set oRS=oDBCON.Execute ("Select blah blah rudy is tha man")
> if oRS.BOF and oRS.EOF then
> sizefromdb=Empty

What does BOF mean?  and/or how does it differ from EOF?  Should they both
be used *always* together?

> else
> sizefromtb=oRS(0) ' the first column, this is faster than by name

Thanks for the tip, I presume that field names start at (0), instead of 1.
Anything special depending on whether the field is an auto-incremented

Thanks for all your help.  :)


More information about the thelist mailing list