Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get a value from a stored prcedure via ASP
Message
From
17/10/2001 11:46:05
 
 
To
17/10/2001 11:24:36
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00569635
Message ID:
00569651
Views:
15
>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

Are you calling the sp through ADO or ODBC? Is the value in an output parameter from the stored procedure?

If you are using ADO, add the parameter to a command object and then after calling the sp retrieve its value with something like:
myValue = oCmd.Parameters("myOutput").Value
Also check out this ADO-stored procedures design-time tool from the UT downloads: http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1196
HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform