|
|
|
|
|
| | |
|
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)

|
|
Subject: |
Re: Stored Procedures |
From: |
Joshua |
Date: |
8/31/2000 8:43:16 PM |
IP: |
129.118.50.150 |
Set theRecordset = Server.CreateObject("ADODB.Recordset")
Set theStoredProc = Server.CreateObject("ADODB.Command")
theStoredProc.ActiveConnection = whatever connection is open
theStoredProcedure.CommandText = "name of procedure or CALL statement)"
initialize parameters
Set theRecordset = theStoredProc.Execute , paramenters
Then navigate theRecordset like you normally would, with MoveNext, etc. |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|