Re: Possibly Silly q

I guess it depends on the RDBMS server.
I would expect an implicit close, but I can imagine that the documentation states that it's unpredictable behaviour.

-- Peter.

-----Origineel bericht-----
Van:Bruce Johnson
Verz.: 2012-07-01, 00:05 
Aan: [email protected]
Ondrw.: Possibly Silly q


Does a new execution of a cursor clear out any existing data or do I have to close the cursor?


I have a situation where I'll step through a cursor, fetching rows and might break out of the loop before retrieving all the rows. Then the enclosing loop I'll execute the cursor with a new parameter. DO I have to do $csr->close(); ?

 or can I just do $csr->execute($param); 

again?


-- 
Bruce Johnson

"Wherever you go, there you are" B. Banzai,  PhD