Forums

This topic is locked

Just some basic questions

Posted 17 Sep 2001 14:27:46
1
has voted
17 Sep 2001 14:27:46 Nam Lee posted:
Hello Everybody.

Just have some problems understanding some codes in ASP.

Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery

Above the codes, just want to ask what is the ADODB.Command all about? I
seen that quite often??
Another question is concerning about MM_editQuery. Is that a self-declared
variable? Can I type another name for that variable? What does the
CommandText do??



Replies

Replied 18 Sep 2001 14:35:45
18 Sep 2001 14:35:45 Joel Martinez replied:
All great questions...
the adodb.command allows you to:
-perform non-Query SQL statements
-return a recordset
-execute a Stored procedure

I personally would argue that you can do the same thing with an adodb.connection, but that's getting a bit deep into it.

MM_editQuery is simply the name that they've given to the variable holding the SQL statement (the commandText property is just the variable that holds the SQL statement in the command)...
I wouldn't mess with Server Behavior code unless you plan to hand code the rest... read this FAQ about that
www.udzone.com/showDetail.asp?TypeId=7&NewsId=1197

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Reply to this topic