General information
Category:
Internet applications
Hi , something doesn't work..i got a error at the line cmd.execute
here is the code i'm using :
dim conn, cmd, returnvalue
Set cmd = Server.CreateObject("ADODB.Command")
Set conn = Server.CreateObject("ADODB.Connection")
conn.mode = 16
conn.Open "Provider=VFPOLEDB.1 ; Data Source=C:\vfp\test\Mydatabase.dbc"
set cmd.activeconnection = conn
cmd.commandtype = adCmdStoredProc
cmd.commandtext = "myproc"
cmd.parameters(1) = "param"
cmd.execute
returnvalue = cmd.parameters(1)
RESPONSE.WRITE(RETURNVALUE)
>Hi!
>
>In ASP you probably use ADO, so I will write this for ADO (also assuming you use VB script, not a JavaScript):
>
> Set cmdComm = New ADODB.Command
> Set cmdComm.ActiveConnection = objConn
> cmdComm.CommandType = adCmdStoredProc
> cmdComm.CommandText = "MySPName"
>
> ' at this moment most likely (for SQL Server OLEDB provider) Command object already will know all
> 'arameters and parameters collection will contain "RETURN_VALUE" parameter
> ' maybe add some parameters for SP here to the command obect parameters collection
> '...
>
> cmdComm.Execute
> If cmdComm.Parameters("RETURN_VALUE").Value <> 0 Then
> ....
>
>HTH.
>
>>How can i get the value turned back by a stored procedure using ASP ?
>>I can invoke it but I don't know how to get the result
>>
>>Thank u
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only