[thelist] ASP, SQL, Recordsets, Best Practices
Michele Foster
michele at wordpro.on.ca
Thu Mar 1 15:19:03 CST 2001
Scott,
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
field?
Thanks for all your help. :)
Michele
More information about the thelist
mailing list