The statement parameter can only be a single select or a single stored

[Deadline]

"The statement parameter can only be a single select or a single stored procedure"

- I get the above error message, when I try to execute the following inside a FOR loop

Set rs = Server.CreateObject("ADODB.Recordset")
FOR i = 0 to UBOUND(somearray)

...
...

rs.Open sSQLEvent, cn,2
mArray = Split(rs.GetString(2,,",",","),",")
rs.Close
NEXT

Thank you,
RR.
__________________________________
The best is yet to come.

 

[rac2]

what is in sSQLEvent?

 

[Deadline]

It is a simple SQL SELECT Statement. I apologise for not making it clear.

Thank you,
RR.
__________________________________
The best is yet to come.