[thelist] ASP, SQL, Recordsets, Best Practices

[Michele Foster]

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