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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
