For starters the CF drivers won't let you attempt to execute multiple statements in a single cfquery like that (though I believe this can be changed with connection string arguments). Try moving the loop outside of the cfquery tags so that each query runs within a single cfquery tag.
On Mon, Oct 6, 2008 at 11:12 AM, Simon Bailey <[EMAIL PROTECTED]> wrote: > Ok hands up I sounded like a dumb a$$. Its the loop query aspect I > had an issue with and thought I would test the water if I was on the > right logic from the get go before I questioned the below code as it > is failing somehow: > > <cfquery name="qResult" datasource="#dsn#"> > > <cfloop > array="#arguments.aRecord.course_results#" index="i"> > > <cfset datum = structNew()> > <cfset datum = > arguments.aRecord.course_results[i]> > > UPDATE c_results > > SET rating = > #datum.rating#, > comment = '#datum.comment#' > > WHERE course_id = #datum.course_id# > > </cfloop> > > </cfquery> > > On 6 Oct 2008, at 15:44, Tom Chiverton wrote: > > On Monday 06 Oct 2008, Simon Bailey wrote: > > I have a relatively straight forward question I was wondering if > > people may shed some light on. I am passing a value object from Flex > > to CF which has a course_id, course_name and an Array of values. In > > my method in my cfc I would like to update one mysql table with the > > course_id + course_name and another table with the array contents. > > Err, right ? > And ? > cfquery, cfloop, cfquery ? > > -- > Tom Chiverton > Helping to interactively establish six-generation eye-catching B2B > clusters > > > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in > England and Wales under registered number OC307980 whose registered > office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, > Manchester, M3 3EB. A list of members is available for inspection at > the registered office. Any reference to a partner in relation to > Halliwells LLP means a member of Halliwells LLP. Regulated by The > Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above > and may be confidential or legally privileged. If you are not the > addressee you must not read it and must not use any information > contained in nor copy it nor inform any person other than Halliwells > LLP or the addressee of its existence or contents. If you have > received this email in error please delete it and notify Halliwells > LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
