Hey guys thanks for that,
@brian I tried your suggestion to no avail:
<cfloop array="#arguments.aRecord.course_results#" index="i">
<cfquery name="qResult" datasource="#dsn#">
UPDATE c_results
SET rating =
#arguments.aRecord.course_results[i].rating#,
comment =
'#arguments.aRecord.course_results[i].comment#'
WHERE result_id =
#arguments.aRecord.course_results[i].result_id#
</cfquery>
</cfloop>
Stripped out the datum struct also to try and simplify matter. I have
debugged flex and I know the params are fine being passed in? Anything
glaringly obvious here?
Course results is the array, rating is a number, and comment is a
string.
Cheers,
Simon
On 6 Oct 2008, at 19:13, Brian Kotek wrote:
Like I said, you can enable this in the JDBC connection string. It is
simply
off by default due to the security ramifications of allowing multiple
statements by default.
On Mon, Oct 6, 2008 at 1:58 PM, Justin Scott <[EMAIL PROTECTED]>
wrote:
> Brian Kotek wrote:
>> Well it definitely doesn't in MySQL but obviously YMMV depending on
>> platform.
>
> Well, I can't help it that MySQL is an inferior platform. ;)
>
> /me runs away in a zig-zag pattern while ducking and covering his
> head.
>
>
> --
> Justin Scott, http://www.tlson.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:313498
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
