Re: Retrieving Dataset along with REcordsets

2008-09-13 Thread NoName ForMe
2008/9/13 Dr.Ruud <[EMAIL PROTECTED] <[EMAIL PROTECTED]>> > jeevs schreef: > > > fetch returns me all the results but it just doesn't know when to stop > > i.e > > while (my @arr = $sth->fetch){ > > print Dumper @arr; > > } > > it goes in infinite loop > > while (my @arr = $sth->fetch) ->thi

Re: Retrieving Dataset along with REcordsets

2008-09-13 Thread Dr.Ruud
jeevs schreef: > fetch returns me all the results but it just doesn't know when to stop > i.e > while (my @arr = $sth->fetch){ > print Dumper @arr; > } > it goes in infinite loop Are you using DBIx::Simple? -- Affijn, Ruud "Gewoon is een tijger." -- To unsubscribe, e-mail: [EMAIL PROTE

Re: Retrieving Dataset along with REcordsets

2008-09-12 Thread jeevs
On Sep 11, 7:12 pm, [EMAIL PROTECTED] (Jeevs) wrote: > I understand a $stmt->execute($sql) will return me the recordset and I > can fetch the records using fetchrow_hashref and other methods > > Howeveer I have a scenario where I get multiple datasets, ( Reason : > My Stored Procedure calls oth

Retrieving Dataset along with REcordsets

2008-09-11 Thread jeevs
I understand a $stmt->execute($sql) will return me the recordset and I can fetch the records using fetchrow_hashref and other methods Howeveer I have a scenario where I get multiple datasets, ( Reason : My Stored Procedure calls other Stored PRocedures internally.) with individual record sets