Hmm... I am new to this list. Posted this email this afternoon but somehow it never showed up. 2nd try... On Fri, May 30, 2008 at 3:00 PM, Qing Xia <[EMAIL PROTECTED]> wrote:
> Folks: > > I am stuck on trying to get the following block of code to work. I tried > several variations of referring to the 2 dimensional array element in the > query, but have not found a way that agrees with SQL. :-( > > Any ideas and suggestions will be most appreciated! > > > > <!--- Update information on whether a menu item is to be included in the > newsletter issue. ---> > > <cfquery > name="update_stored_newsletter_menu_info" datasource= > "#application.cf_data_source#"> > > <cfset variables.index = 1> > > <cfloop condition = "variables.counter LTE form.number_of_menu_items"> > > *UPDATE* INTERSECTION_newsletter_to_menu > > *SET* include_newsletter_menu = #*EVALUATE* > (variables.newsletter_menu_array[index][1])# > > *WHERE* newsletter_info_id = #form.newsletter_info_id# > > *AND* newsletter_to_menu_id = #*EVALUATE* > (variables.newsletter_menu_array[index][2])# > > <cfset variables.index = variables.index + 1> > > </cfloop> > > </cfquery> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
