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? -- 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] >> >> > >
-- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]