6 Replies Latest reply: Mar 22, 2013 1:36 AM by ThomasMIP RSS

    HTML CFGRID not passing all modified values

    jarviswabi Community Member
    jarviswabi Dec 19, 2012 12:22 PM

      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?

        • 1. Re: HTML CFGRID not passing all modified values
          BKBK Community Member
          BKBK Dec 22, 2012 6:48 AM (in response to jarviswabi)

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

          • 2. Re: HTML CFGRID not passing all modified values
            relaxatraja Community Member
            relaxatraja Feb 15, 2013 8:42 PM (in response to jarviswabi)

            I have the same issue, did you solveD?

            • 3. Re: HTML CFGRID not passing all modified values
              ThomasMIP Community Member
              ThomasMIP Mar 6, 2013 6:56 AM (in response to BKBK)

              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>
              • 4. Re: HTML CFGRID not passing all modified values
                Elwood123Bermuda Community Member
                Elwood123Bermuda Mar 19, 2013 11:03 AM (in response to ThomasMIP)

                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.

                • 5. Re: HTML CFGRID not passing all modified values
                  Elwood123Bermuda Community Member
                  Elwood123Bermuda Mar 19, 2013 11:48 AM (in response to Elwood123Bermuda)

                  Did you ever figure this out?

                  • 6. Re: HTML CFGRID not passing all modified values
                    ThomasMIP Community Member
                    ThomasMIP Mar 22, 2013 1:36 AM (in response to Elwood123Bermuda)

                    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.