Re: Using Cursors in PHP

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Markus Bertheau <twanger(at)bluetwanger(dot)de>, Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>, pgsql-php(at)postgresql(dot)org
Subject: Re: Using Cursors in PHP
Date: 2003-08-08 13:42:11
Message-ID: 1060350130.97914.4.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

> 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.

Yup.. This is where you setup a little Java to deal with persistent
database elements like this and hook into it via PHP. It's a little
nasty at the moment (though functional) but is supposedly greatly
improved in PHP 5.

http://ca2.php.net/manual/en/ref.java.php

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Bruce Momjian 2003-08-08 17:34:43 Re: Using Cursors in PHP
Previous Message scott.marlowe 2003-08-08 13:33:25 Re: Using Cursors in PHP