Recordset Issue

[zzfive03]

I have a scrollable record set:
Set RS = Server.CreateObject("ADODB.Recordset&quot
RS.Open SQL, DB, adOpenKeySet

It works fine when I run regualr ad hoc queries, but it does not work for stored procedures... and one know how to help?

 

[AWithers]

You need to use slightly different code for stored procedures using the command object

dim objcommand

set objcommand = server.createobject("adodb.command&quot
objcommand.commandtext = "yourprocedurename"
objcommand.commandtype = adcmdstoredproc
set rs = objcommand.execute

you could change your code to trap whether it is a query or stored proc and run the relevant bit of code

Andy