how to use stored procedures in ASP, need help plz

[taval]

I currently have several SQL procedures on an SQL server, I would like to know if its possible to execute these from an asp script and how I would go about doing so?<br><br>Grateful for any help, thanks.

 

[onetomany]

This should allow you to use a stored procedure. This example uses a paramter intassociateID to use a Stored PRoc without a paramter just omit&nbsp;&nbsp;('&quot; & intAssociateID & &quot;') from the recordset open statment.<br><br><br>dim conntemp,rstCredits,intAssociateID,arstIncident,arstBenefitDays<br>&nbsp;&nbsp;&nbsp;<br>set conntemp=server.createobject(&quot;adodb.connection&quot<br>conntemp.open &quot;Provider=SQLOLEDB; Data Source=yourserver; Initial Catalog=yourdatabase;User ID=xxxx;Password=xxxx&quot;<br>&nbsp;&nbsp;&nbsp;<br>intAssociateID = request.QueryString(&quot;ID&quot<br>&nbsp;&nbsp;<br>set arstCredits=server.createobject(&quot;adodb.recordset&quot<br>&nbsp;&nbsp;<br>arstCredits.open&quot;sp_get_CreditBalance('&quot; & intAssociateID & &quot;')&quot;,conntemp_<br>,adOpenStatic,adLockOptimistic,adcmdStoredProc

 

[taval]

I'm a bit new to this stuff, could u plz simplify this if possible. Heres a snippet of my code if it helps to explain.<br><br>--------------------------------------------------<br>StrQuery = &quot;Select * from Customer Order by CustId&quot;<br>Set allcust = Server.CreateObject (&quot;ADODB.Recordset&quot<br>allcust.Open StrQuery ,&quot;DSN=Architron; UID=sa; PWD=&quot;<br>--------------------------------------------------<br><br>Lets say my stored procedure was called findCustomer how would I execute this on my database/recordset?<br>