Groups | Blog | Home
all groups > inetserver asp db > november 2005 >

inetserver asp db : need help defining what I am doing


seventhpoint NO[at]SPAM gmail.com
11/16/2005 8:06:19 PM
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.
Bob Barrows [MVP]
11/17/2005 6:36:08 AM
[quoted text, click to view]

It's an ADODB Recordset object

[quoted text, click to view]

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

[quoted text, click to view]

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/mdmscmicrosoftadoprogrammersreference.asp

A good starting point is
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmscadoprogrammersguide.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"

AddThis Social Bookmark Button