Re: execute and closeCursor for PDO??
| From: | Wez Furlong | 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
>
>