Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using OLE DB and asp
Message
From
17/10/2001 01:48:45
 
 
To
13/10/2001 09:47:59
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00568144
Message ID:
00569413
Views:
20
Hi there , i suppose it was a simple sintax error as i wrote Datasource instead Data Source, or at least i think it was it seen that now it works.
Now I have another problem, i can execute my stored procedure which writes on a table but..how can I retrieve the value it should give me back ?
I use this ASP instructions to execute the routine :

conn.ConnectionString="Provider=VFPOLEDB.1 ; Data Source=C:\vfp\test\MyDataname.dbc"
conn.Open
sql = "mystoredproc('param')"
set retid =conn.Execute(sql)

but i don't know how to get the value back from the routine i called.
I tried with
Response.write (retid)

but it gives me an error

Any suggestion ?
Thank u again
Alessio
Previous
Reply
Map
View

Click here to load this message in the networking platform