I am using cfgrid to display a form that users can enter scores. The grid
is populated with more than one table, so I have to loop through all the
arrays in the form variables. When I try to insert these variables my
server hangs, I can display them though. I am using CF Server 4.5, oracle
and solaris. Anyone know why? I have tried everything. I have set the
variables locally too. Here's my code.
<cfloop index="row" from="1" to="#arraylen(form.tablegrid.RowStatus.Action)#">
<cfif form.tablegrid.RowStatus.Action[row] IS "U">
<cfoutput>
<cfset attributes.item_id = #form.tablegrid.item_id[row]#>
<cfset attributes.foundry_id = #form.tablegrid.foundry_id[row]#>
<cfset attributes.score = #form.tablegrid.score[row]#>
<cfset attributes.note = "#htmleditformat(form.tablegrid.note[row])#">
<cfset attributes.userid = #form.tablegrid.userid[row]#>
<cfset attributes.id = #form.tablegrid.id[row]#>
<cfset attributes.userid = #form.tablegrid.userid[row]#>
</cfoutput>
<cfquery datasource="SCORE" name="update">
UPDATE card
SET ITEM_ID = #attributes.item_id#,
FOUNDRY_ID = #attributes.foundry_id#,
SCORE = #attributes.score#,
NOTE = '#attributes.note#',
USERID = #attributes.userid#,
DATECREATED = #attributes.now()#
WHERE id = #attributes.id#
and
userid = #attributes.userid#
</cfquery>
</cfif>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
