I asked this over on cf-talk but haven't gotten a response yet. I'm hoping maybe I could get one here.
I installed the developer version of CF9 on my machine. I moved over some code that I had originally done in CF8 and the CFGRID just broke. <cfquery name="getOutcome" datasource="#application.dsn#"> select * from l_outcomes </cfquery> <cfquery name="getSerious" datasource="#application.dsn#"> select * from l_serious_criteria </cfquery> <cfset variables.outcome = valuelist(getOutcome.outcome)> <cfset variables.serious = valuelist(getSerious.serious_criteria)> <cfform name="event_form" action="event_action.cfm" method="post"> <cfgrid format="html" name="event" selectmode="edit" insert="yes" delete="yes"> <cfgridcolumn name="reported_terms" header="Reported Terms"> <cfgridcolumn name="onset_date" header="Onset Date" type="date" mask="dMY"> <cfgridcolumn name="outcome" header="Outcome" values="#variables.outcome#" valuesdisplay="#variables.outcome#" select="true"> <cfgridcolumn name="abated_date" header="Abated Date" type="date" mask="dMY"> <cfgridcolumn name="serious_criteria" header="Serious Criteria" values="#variables.serious#" valuesdisplay="#variables.serious#" select="true" width="600"> </cfgrid> </cfform> The error message I get when I try to add in more than one row is: "uncaught exception: Multiple row insert is not supported" Any idea what is wrong? I don't see any patches for CF9. Using CF9 Developer edition version 9. 0. 0. 251028 TIA W ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:308339 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
