This is not standard SQL so most databases won't support it.
Access is supposed to support this kind of updates, but then it won't work
on other db's
A "better" way to do this is to issue two separate inserts right after each
other within a transaction.
But this will also crash some databases as not all databases support
transactions, notably MySQL
and Access. However oracle, db2, interbase, .... do support this kind of
thing and this is the standard
way of handling multiple connected sql commands.
The simple way is to issue two separate inserts right after each other
without transactions but this might
lead to concurrency problems
Robert Klinkenberg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
