Re: Problems connecting
"Martin J. Evans" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Organization | Easysoft Ltd |
| Message-ID | <[email protected]> |
Aaron, Appologies, I mistook you for the original poster. Martin -- Martin J. Evans Easysoft Ltd, UK http://www.easysoft.com On 20-Jul-2006 Martin J. Evans wrote: > On Thu, 2006-07-20 at 14:40 -0700, A. Gerow wrote: >> I'm pretty sure one can fetch only the first couple rows in a return-set >> and still be ok. >> The general idea is: >> $dbh-> connect(...) >> >> $sth=$dbh->prepare(sql_stmt) >> $sth->execute() >> $sth->fetch() # different for different kinds of returns. >> $sth->finish() # Are you missing this? >> ... >> >> $dbh->disconnect() # Your error. > > But the error indicates you are not calling finish. > > You never said you were calling finish AND getting the error. > > As far as I am aware you WILL get this error it you do not call finish > and have not fetched all the results. > > Martin > -- > Martin J. Evans > Easysoft Limited > http://www.easysoft.com >> Martin J. Evans wrote: >> > The error "disconnect invalidates 1 active statement handle" implies >> > you have an active statement for which all results have not been fetched >> > when you call disconnect. e.g. >> > >> > prepare(some sql) >> > execute >> > fetch one row when there are 20 rows >> > >> Right here one should call $sth->finish() >> > disconnect (or script terminates) >> > >> > As the error states, if you don't fetch all the results from a select >> > then call finish first or fetch all the results. >> > >> > I cannot tell from your description how "this works on one server" >> > and not another. >> > >> > Martin >> > >> >> -- >> Aaron Gerow >> Open Source Developer >> Digital Media - Information and Technology Services >> Pacific Lutheran University >> Tacoma, Washington >> -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]