MDB execute multiple

From: Date: Mon, 05 May 2003 10:11:11 +0000
Subject: MDB execute multiple
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-5229@lists.php.net to get a copy of this message
Hi Lukas, Running an executeMultiple() gives me an error - Query set: it was not specified a valid argument number- when my quert looks like this:
       $query = 'UPDATE docsections SET section_id='.$db->getIntegerValue($move_to).' WHERE doc_id=!';
       $pquery = $db->prepareQuery($query);
       $result = $db->executeMultiple($pquery, null, $doc_id);
It works like this:
       $query = 'UPDATE docsections SET section_id='.$db->getIntegerValue($move_to).' WHERE doc_id=?';
       $pquery = $db->prepareQuery($query);
       $result = $db->executeMultiple($pquery, null, $doc_id);
I thought I could use the ! in MDB to identify integers. Here's the debug output 1 PrepareQuery: UPDATE docsections SET section_id=35 WHERE doc_id=! Jeroen

« previous php.pear.general (#5229) next »