I'm trying to delete many records from a table and I'm using quite a long condition.
I've printed $cond->sql and the correct clause is showing. When I do:
$DB->table('Links')->delete( $cond );
....it doesn't delete anything nor does $GT::SQL::error say anything.
I tried doing a select rather than a delete with mysqlman to see what happened and it produced 26,000 results.
Any ideas?
Oh also...will the delete clean up the CatLinks table too?
I've printed $cond->sql and the correct clause is showing. When I do:
$DB->table('Links')->delete( $cond );
....it doesn't delete anything nor does $GT::SQL::error say anything.
I tried doing a select rather than a delete with mysqlman to see what happened and it produced 26,000 results.
Any ideas?
Oh also...will the delete clean up the CatLinks table too?