[snip]
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
[/snip]
You need a while loop. Does the SP work from the command line properly?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Would you care to send the source of that procedure plus tell us why
you believe it works when called by something other than C#?
On 5/30/07, Critters <[EMAIL PROTECTED]> wrote:
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
--
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
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 quest
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
respons