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?

<sql>
UPDATE Item SET Category='null' WHERE Category='somecategory'
</sql>

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
deleted.

Any thoughts?

Thanks

Cameron



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


Mime
View raw message