MDB execute multiple
| From: | Jeroen Houben | 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