Re: HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Wed, 20 Mar 2013 09:33:18 GMT

That's exactly the same behaviour we experience, and describes the problem very well.

Looking in the manual (cfgrid), there is a Note "...Adobe recommends that after user updates data in a cell, they click another cell before submitting the form."

Meanwhile i put that issue on the bug-tracklist.

Re: HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Tue, 19 Mar 2013 18:48:41 GMT

Did you ever figure this out?

Re: HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Tue, 19 Mar 2013 18:03:28 GMT

Not sure if this was your issue but I have the same problem and have narrowed it down to how you exit the cell you just edited. If you tab or enter it assigns the data properly but if you click with the mouse on another field it seems the data you entered gets marked internally to the field you just clicked to.

Re: HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Wed, 06 Mar 2013 14:53:42 GMT

Same Problem.

Because of recent Java security issues we decided to change the format of our controls from applet to html. Thus our client doesn’t need the JRE anymore.

We used the cftree and the cfgrid control. The format change of the cftree-control was not as easy as expected, but after several hours we fixed the display of the control. Now it works fine. By the way that was not our understanding of rapid prototyping.

The change of the cfgrid control was quite easy, just changing the format and adjusting some parameters. Looks fine and ready to use. But we have encountered serious problems, which we are unable to fix. Like in http://forums.adobe.com/message/5077649#5077649 and http://forums.adobe.com/message/4606378#4606378 mentions, not all modified values are transferred to the actionpage.

It seems that modified checkboxes are transferring data in the right way, but changes to a dropdown, or text cells does not always force the modified dataset to be sent. In some cases even a wrong data row is sent.

We are using CF902 and will be migrating to CF10, tests with CF10 show the same behaviour.

We would greatly appreciate a solution for this issue.

For further research here is a sample of a self running demo code.

<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Gridtest</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="expires" content="0">
</head>
<body>
<!--- Display Formparameter --->
Form.Var: <cfdump var="#Form#">

<!--- Action --->  
<cfif isdefined("Form.Teilnehmerliste.RowStatus.Action")>
 <cfloop index="x" from="1" to="#arraylen(Form.Teilnehmerliste.RowStatus.Action)#">
  <!--- Datenbank aktualisieren --->
  <cfif #Form.Teilnehmerliste.RowStatus.Action[x]# eq 'U'>
   update <br>
  <cfelseif #Form.Teilnehmerliste.RowStatus.Action[x]# eq 'I'>
   <!--- Insert --->
  <cfelse>
   <!--- Delete --->
  </cfif>
 </cfloop>
 <cfabort>
</cfif><!---  isdefined("Form.Teilnehmerliste.RowStatus.Action") --->

<!--- Make a query of 5 records --->
<cfset xtnliste = QueryNew("Personalnummer,Anmeldung_ID,Termine_ID,Name,Vorname,Status,Tage,Privatanschrift")>
<!--- 1 --->
<cfset temp = QueryAddRow(xtnliste)> 
<cfset temp = QuerySetCell(xtnliste, "Personalnummer", "0000015")>
<cfset temp = QuerySetCell(xtnliste, "Anmeldung_ID", 54282)>
<cfset temp = QuerySetCell(xtnliste, "Termine_ID", 4711)>
<cfset temp = QuerySetCell(xtnliste, "Name", "Name1")>
<cfset temp = QuerySetCell(xtnliste, "Vorname", "Petra")>
<cfset temp = QuerySetCell(xtnliste, "Status", "Z")>
<cfset temp = QuerySetCell(xtnliste, "Tage", 35)>
<cfset temp = QuerySetCell(xtnliste, "Privatanschrift", 1)>
<!--- 2 --->
<cfset temp = QueryAddRow(xtnliste)> 
<cfset temp = QuerySetCell(xtnliste, "Personalnummer", "0004015")>
<cfset temp = QuerySetCell(xtnliste, "Anmeldung_ID", 55152)>
<cfset temp = QuerySetCell(xtnliste, "Termine_ID", 4711)>
<cfset temp = QuerySetCell(xtnliste, "Name", "Name2")>
<cfset temp = QuerySetCell(xtnliste, "Vorname", "Anja")>
<cfset temp = QuerySetCell(xtnliste, "Status", "Z")>
<cfset temp = QuerySetCell(xtnliste, "Tage", 41)>
<cfset temp = QuerySetCell(xtnliste, "Privatanschrift", 0)>
<!--- 3 --->
<cfset temp = QueryAddRow(xtnliste)> 
<cfset temp = QuerySetCell(xtnliste, "Personalnummer", "2565210")>
<cfset temp = QuerySetCell(xtnliste, "Anmeldung_ID", 55153)>
<cfset temp = QuerySetCell(xtnliste, "Termine_ID", 4711)>
<cfset temp = QuerySetCell(xtnliste, "Name", "Name3")>
<cfset temp = QuerySetCell(xtnliste, "Vorname", "Holgi")>
<cfset temp = QuerySetCell(xtnliste, "Status", "W")>
<cfset temp = QuerySetCell(xtnliste, "Tage", 0)>
<cfset temp = QuerySetCell(xtnliste, "Privatanschrift", 0)>
<!--- 4 --->
<cfset temp = QueryAddRow(xtnliste)> 
<cfset temp = QuerySetCell(xtnliste, "Personalnummer", "2577210")>
<cfset temp = QuerySetCell(xtnliste, "Anmeldung_ID", 55157)>
<cfset temp = QuerySetCell(xtnliste, "Termine_ID", 4711)>
<cfset temp = QuerySetCell(xtnliste, "Name", "Name4")>
<cfset temp = QuerySetCell(xtnliste, "Vorname", "Hilde")>
<cfset temp = QuerySetCell(xtnliste, "Status", "B")>
<cfset temp = QuerySetCell(xtnliste, "Tage", 0)>
<cfset temp = QuerySetCell(xtnliste, "Privatanschrift", 0)>
<!--- 5 --->
<cfset temp = QueryAddRow(xtnliste)> 
<cfset temp = QuerySetCell(xtnliste, "Personalnummer", "2333585")>
<cfset temp = QuerySetCell(xtnliste, "Anmeldung_ID", 55200)>
<cfset temp = QuerySetCell(xtnliste, "Termine_ID", 4711)>
<cfset temp = QuerySetCell(xtnliste, "Name", "Name5")>
<cfset temp = QuerySetCell(xtnliste, "Vorname", "Peter")>
<cfset temp = QuerySetCell(xtnliste, "Status", "Z")>
<cfset temp = QuerySetCell(xtnliste, "Tage", 10)>
<cfset temp = QuerySetCell(xtnliste, "Privatanschrift", 0)>
<!--- Display Form --->
 
<cfform action="gridtest.cfm" method="post" target="_blank" name="teilnehmer">
<cfgrid name="Teilnehmerliste" 
format="html"
query="xtnliste" 
title="Teilnehmerliste"
width="600" height="180"
insert="no" delete="no" sort="no"
bold="No" italic="No" 
appendkey="yes"  highlighthref="No"
griddataalign="left" gridlines="Yes" bgcolor="##ffffff" stripeRows="yes" stripeRowColor="##ededed"<!---  onValidate="Grid_Val"  --->
rowheaders="no" rowheaderalign="right" rowheaderitalic="No" rowheaderbold="No" 
colheaders="Yes" colheaderalign="center" colheaderitalic="No" colheaderbold="No" <!--- onError="Grid_Error" --->
selectcolor="##dde3eb" selectmode="edit" picturebar="No" autowidth="yes">
<!--- Spalten definieren --->
    <cfgridcolumn name="Personalnummer" dataalign="LEFT" bold="yes" italic="No" select="No" display="yes" headerbold="No" headeritalic="No">
 <cfgridcolumn name="Anmeldung_ID" dataalign="LEFT" bold="yes" italic="No" select="No" display="yes" headerbold="No" headeritalic="No">
 <cfgridcolumn name="Termine_ID" dataalign="LEFT" bold="yes" italic="No" select="No" display="no" headerbold="No" headeritalic="No">
 <cfgridcolumn fontsize="11" name="Name" dataalign="LEFT" bold="No" italic="No" select="no" display="yes" headerbold="No" headeritalic="No" href="data.cfm" hrefkey="Personalnummer" target="_self">
 <cfgridcolumn fontsize="11" name="Vorname" dataalign="LEFT" bold="No" italic="No" select="no" display="yes" headerbold="No" headeritalic="No">
 <cfgridcolumn fontsize="11" name="Status" dataalign="LEFT" bold="No" italic="No" select="yes" display="yes" headerbold="No" headeritalic="No" values="B,Z,W,R,A" valuesdisplay="Bewerbung, Zugelassen, Warteliste, Rueckzug, Abgelehnt" valuesdelimiter=",">
    <cfgridcolumn width="50" fontsize="11" name="Tage" dataalign="RIGHT" bold="No" italic="No" select="yes" display="yes" headerbold="No" headeritalic="No" type="numeric">
 <cfgridcolumn name="Privatanschrift" header="Privat" dataalign="LEFT" bold="No" italic="No" select="yes" display="yes" headerbold="No" headeritalic="No" type="boolean">
</cfgrid>
 <input type="submit" value="Änderungen speichern">
</cfform> 
</body>
</html>

Re: HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Sat, 16 Feb 2013 04:42:22 GMT

I have the same issue, did you solveD?

Re: HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Sat, 22 Dec 2012 14:48:33 GMT

Could we see how you define the grid tag(s), including attributes?

HTML CFGRID not passing all modified values

forums_noreply@adobe.com — Wed, 19 Dec 2012 20:22:56 GMT

I've got an HTML type CFGRID (using CF10) and keep running into this issue where it's not passing all the fields that I modify. Say I have 5 rows, and I modify the same 3 columns in all 5 rows (entering prices). All 15 cells get the little red modified indicator, but when I submit the form, the resulting form variables don't contain all the changes. I'm dumping out the form object, and looking at the "grid.rowstatus.action" array to find which rows need updating, as well as the individual arrays containing each column's data.

I can't see any pattern to why it sometimes omits rows or even just cells I've modified. And it's not always the same, and sometimes it gets it right. I haven't been able to find any references to similar behavior, so I'm kind of stumped, and at this point, I may have to ditch the cfgrid and try a JQuery grid of some sort to see if it works better.

Anyone have any ideas?

Adobe Community: Message List - HTML CFGRID not passing all modified values

Re: HTML CFGRID not passing all modified values

Re: HTML CFGRID not passing all modified values

Re: HTML CFGRID not passing all modified values

Re: HTML CFGRID not passing all modified values

Re: HTML CFGRID not passing all modified values

Re: HTML CFGRID not passing all modified values

HTML CFGRID not passing all modified values