need help defining what I am doing

Ok, so I am learning ASP by just piecing stuff together and learning
from what I can find online. I have a SQL command set in a variable
called strSqlCommand. I also have something setup like this: Set db =
Server.CreateObject("ADODB.Connection")

Then I have a line in my script like this: set dbCall =
db.Execute(strSqlCommand)

Everything works fine, which is great, I just wish I understood it a
litle bit more.

My question is, what is dbCall considered how can I look it up? I want
to look into what functions I can add to it, like dbCall.eof.

I probably just need to make my boss buy me an ASP book but until then.

Re: need help defining what I am doing

seventhpoint@gmail.com wrote:
> Ok, so I am learning ASP by just piecing stuff together and learning
> from what I can find online. I have a SQL command set in a variable
> called strSqlCommand. I also have something setup like this: Set db =
> Server.CreateObject("ADODB.Connection")
>
> Then I have a line in my script like this: set dbCall =
> db.Execute(strSqlCommand)
>
> Everything works fine, which is great, I just wish I understood it a
> litle bit more.
>
> My question is, what is dbCall considered how can I look it up?

It's an ADODB Recordset object

> I
> want to look into what functions I can add to it, like dbCall.eof.

"add to it"? EOF is a property of the recordset object, not a function that
you added to it.

>
> I probably just need to make my boss buy me an ASP book but until
> then.

Actually, for these question, you need a book about ADO (David Sceppa's
"Programming ADO" is pretty good, as well as Bill Vaughn's "ADO Examples and
Best Practices"), but until then, go to the source:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmscmicr osoftadoprogrammersreference.asp

A good starting point is
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmscadop rogrammersguide.asp

--
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"