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