On 8 Aug 2003, Markus Bertheau wrote: > Ð? СÑ?д, 06.08.2003, в 17:51, scott.marlowe пиÑ?еÑ?: > > On Wed, 6 Aug 2003, Andreas Schmitz wrote: > > > > > > > > Hello *, > > > > > > I am just wondering if it is possible to use cursors within PHP. I need to > > > page query result from a big table and I am looking for a solution to avoid > > > scanning the complete table using limit and offset. > > > > Yes, you can use cursors, no you can't expect them to survive from one > > page to the next. > > What about the new feature in cursors "WITH HOLD"? Don't they survive? I don't think so. Basically, PHP is supposed to reset the connection if it's persistant, and if it isn't persistant, then it's always a new connection, which means a cursor shouldn't survive. But I'm NOT familiar with "WITH HOLD" right now, so someone else who knows that better may have a more definitive answer.
