If you have a sql server stored procedure that returns a recordset (i.e. returns a select statement), here is how you use it in an ASP page: Dim adoCon Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Password=password;Initial Catalog=Database;Data Source=sqlserver" Dim rs99 Set rs99 = Server.CreateObject("ADODB.Recordset") set rs99 = adocon.execute("exec spGetPriceList '" & customerfeed & "'") Do while not rs99.eof rs99.movenext Loop rs99.close Set rs99=Nothing |
ASP >