The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
--
Dave
Michael Dykman wrote:
Surely, you don't have legacy stored procedure in ASP under MySQL?
are you sure this is the right list to be asking?
- michael
On 5/30/07, Critters <[EMAIL PROTECTED]> wrote:
Hi
How do you get multiple record sets from a stored procedure in legacy
ASP? It doesn't seem to work for us.
The question is how to return multiple record sets from a single stored
procedure which myodbc doesn't seem to support?
set rs = connection.execute(strSQLsp)
If not rs.EOF then
response.write rs(1)
End if
set rs = rs.NextRecordset
If not rs.EOF then
response.write rs(2)
End if
We only get the first response.write
Thanks
--
David Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]