Re: execute and closeCursor for PDO??

From: Date: Tue, 25 Oct 2005 15:43:28 +0000
Subject: Re: execute and closeCursor for PDO??
References: 1 2 3 4 5 6 7 8 9 10  Groups: php.pecl.dev 
Request: Send a blank email to pecl-dev+get-3157@lists.php.net to get a copy of this message
It's not a bug, that's the way it works. --Wez. On 10/25/05, Richard Thomas <lists@cyberlot.net> wrote: > A note on this.. If I change my fetch to fetchAll the cursor seems to be > properly closed and it does work. > > So basically a fetch on a single row does not close the cursor, not sure > if this would be considered a bug, maybe just further doc's needed on > the fetch page. > > > Richard Thomas - CEO > Cyberlot Technologies Group Inc. > 507.398.4124 - Voice > > > Richard Thomas wrote: > > Using E_ALL | E_STRICT > > > > So there should be a clear error when going from one prepared statement > > to another if the cursor from the prior statement is not closed? > > > > I will put together a short example and submit it as a bug, Thanks. > > > > Richard Thomas - CEO > > Cyberlot Technologies Group Inc. > > 507.398.4124 - Voice > > > > > > Wez Furlong wrote: > > > >> If you turn up your error reporting to warning or exception mode, the > >> error message should be quite clear. If no error is indicated, that > >> sounds like a bug. > >> > >> --Wez. > >> > >> On 10/25/05, Richard Thomas <lists@cyberlot.net> wrote: > >> > >>> Not sure if this just needs to be stated on the execute page in the docs > >>> or if its possibly a bug > >>> > >>> In mysql, I only have a single row in the table, I can prepare, execute > >>> and fetch that single row over and over but when I try to use another > >>> statement I had already prepared it doesn't do anything, doesn't error. > >>> > >>> Remembered something about this from mysqli so I quickly figured out the > >>> closeCursor, put this after the fetch and now it all works fine. > >>> > >>> Either a doc, or is this a bug? Since there was only a single row of > >>> data should the connection already been "closed" for further use? > >>> > >>> Richard Thomas - CEO > >>> Cyberlot Technologies Group Inc. > >>> 507.398.4124 - Voice > >>> > >>> -- > >>> PECL development discussion Mailing List (http://pecl.php.net/) > >>> To unsubscribe, visit: http://www.php.net/unsub.phpíëUz èêj Sªò > >>> > >>> > >>> > >> > >> > > > > -- > PECL development discussion Mailing List (http://pecl.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

« previous php.pecl.dev (#3157) next »