note 8823 added to ifx_do
| From: | azhong at nact dot com | Date: | Fri, 29 Sep 2000 09:21:30 +0000 |
| Subject: | note 8823 added to ifx_do | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-5588@lists.php.net to get a copy of this message | ||
ifx_prepare and ifx_do seem not to conform to the conventional Informix ESQL prepare and execute
pairs, which are also found in the DBD::Informix Perl module. For example, if we want to delete a
whole bunch of records, the conventional way wants to do things like this:
prepare prep_curs for delete from a_table where a_id=?;
for ($i=beg_id; $i<=end_id; $i++)
{
execute prep_curs using $i;
}
By doing it this way, we only prepare a statement once and reuse the return optimized query plan
over and over again.
So, are we going to get ifx_prepare and ifx_do functions revised?
http://www.php.net/manual/function.ifx-do.php