On Sep 29, 2010, at 2:41 AM, Serkan Temizel wrote:
Hi,
For security purposes I always limit my delete statements.
$db->delete('user', $db->quoteInto('id_user=?',$idUser))->limit(1);
does not
seem to work.
Documentation does not mention about such limited delete statements.
DELETE with a LIMIT clause is not standard SQL, and as far as I know
it's supported only by MySQL.
Any solutions?
DELETE statements with vendor-specific syntax you should build
manually as strings, and execute them with $db->query().
Regards,
Bill Karwin
