Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to get a value from a stored prcedure via ASP
Message
De
17/10/2001 11:46:05
 
 
À
17/10/2001 11:24:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00569635
Message ID:
00569651
Vues:
16
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform