db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cameron Hickey" <...@panoramatos.com>
Subject UPDATE multiple rows at once
Date Wed, 20 Aug 2003 13:01:56 GMT
I cannot find any reference to doing this on the torque website...

What would be the proper torque criteria and method to use to excecute a
query like this?

UPDATE Item SET Category='null' WHERE Category='somecategory'

Right now, my application is breaking when I delete a row (somecategory)
which is a reference to an FK in another table (Item).  I don't want to
implement some form of referential integrity because the Items should
not be deleted just because the Category they were associated with was

Any thoughts?



To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message