I ran into a problem using deleteByQuery to delete from an aliased table. After a little investigation, I found these oddities.
In Oracle, you can delete from an aliased table if you don't specify "as" between the table name and the alias. For example, "delete from myTable t1" works but "delete from myTable as t1" does not.
SQLServer, mySQL and PostgresSQL don't allow deletes from an aliased table.
My thought is to remove aliases from the deleteByQuery statement and remove the getDeleteAsString function.
Does anyone see problems with doing this (or a better way of handling this)?
Thanks, Beth
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
