Because the user_main table is not the table you're trying to delete data from. This implies a join.
Anyhow, just create a custom method for your delete on your gateway. Doug On 2/1/07, Bryan S <[EMAIL PROTECTED]> wrote:
Beth Thanks. Your question pointed me to the solution. I was adding a field to the default query using: <field source="USER_MAIN" field="USM_USER_LOGIN" alias="USM_USER_LOGIN" /> When I took that out the error went away. I don't really understand why this seems to break the deleteByFields funciton though. I just added that field for display purposes. I don't want to delete anything from that table. Bryan On 2/1/07, Beth Bowden <[EMAIL PROTECTED]> wrote: > > what's the query look like? > > On 2/1/07, Bryan S < [EMAIL PROTECTED]> wrote: > > > > *Message* Can Not Delete By Query With Joins *Detail* You can not use > > a query that has joins when calling delete by query. *Extended Info* > > *Tag Context* D:\Inetpub\wwwroot\reactor\query\query.cfc (100) > > arguments - struct GRU_GROUP_MAIN_ID 2 GRU_GROUP_USER_ID [undefined > > struct element] GRU_USER_MAIN_ID 4 > > deleteByFields in my gateway is returning the message above when I > > pass the arguments shown. A search on deleteByFields here > > http://livedocs.reactorframework.com/Reactor_Documentation.htm > > produced no results > > > > Can anyone tell me what I'm doing wrong or where I could look for > > help. Thanks. > > > > > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- > > Reactor for ColdFusion Mailing List > > [email protected] > > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- Doug Hughes -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
