|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Stored Procedures |
|
From: |
David Beal |
|
Date: |
8/13/2001 4:20:00 PM |
|
IP: |
64.162.117.152 |
While it is possible to do things within the open statment. Some cursor types don't seem to execute correctly. The most reliable way I've found is to create a command object.
set conn = Server.CreateObject("ADODB.Connection")
conn.Open Application("ConnectionString")
Set rs = Server.CreateObject("ADODB.Recordset")
Set objCmd = Server.CreateObject("ADODB.Command")
sql="somerecordset;"
rs.CursorLocation = adCmdTable
rs.LockType = adLockOptimistic
rs.CursorType = adOpenDynamic
objCmd.activeConnection = Conn
objCmd.CommandType = adCmdTable
objCmd.CommandText = sql
objCmd.Parameters.refresh
' if there are parameter enter them here.
' objCmd.Parameters[0] = ""
' objCmd.Parameters[1] = ""
rs.Open objCmd
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
