General information
Category:
Internet applications
THANK U ANYWAY VLAD
>Hi!
>
>Well, what is the error? Did you tried to examine what is in the parameters collection?
>BTW, paramneters collection indexes start from 0, so returning value will be probably in the cmd.parameters(0).value
>
>Maybe somebody else jump in and help, because this works for SQL Server. Do not know about VFPOLEDB...
>
>>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
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