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:306416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
