Excecuting Stored Procedure from ASP

[Guest_imported]

I need to excecute a stored procedure from my ASP.&nbsp;&nbsp;I have already set up the connection.&nbsp;&nbsp;I wanted to know if anyone knew the code that excecutes the stored procedure with parameters.<br><br>Thanks

 

[crystalized]

If you set up a recordset object you can set the parameters on the last tab of the recordset object.<br><br>Alternately you could use a setParameter method. <br><br>Personally I set them on the recordset property pages,&nbsp;&nbsp;I have had luck using session variables as the parameter, and hard coded parameters that I later set using the setParameter method and then requery the recordset. <br><br>I hope that helps some,&nbsp;&nbsp;I have not tried too many things with them, I am still learning myself, but if you want any more info, just post and I will try to answer if I can. <p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>

 

[PatHastings]

There is a great article&nbsp;&nbsp;by Geoffery Pennington on the subject<br>&nbsp;<A HREF="

http://www.asptoday.com/articles/19990831.htm"

TARGET="_new">

http://www.asptoday.com/articles/19990831.htm</A><br><br>If

you end up using the createparameter method then you should also read this article which tells you how to build a simple ASP utility that pretty much writes all the code for you.<br><br><A HREF="

http://www.asptoday.com/articles/19991028.htm"

TARGET="_new">

http://www.asptoday.com/articles/19991028.htm</A><br><br><br>NB.

you will need to use the Createparameter method if your stored procedures use output parameters or return values,<br><br>pat