This problem was posted way back in 2005 but I have not seen a solution to it.
When querying from a database a record that contains a semicolon and displaying
it on a cfgrid if you select that row and try to submit or do anything with it
you will get an error (....submitted cfgrid form field is corrupt ....). Here
is an example of the code used to prove the bug.
<CFSET myQuery = QueryNew("ticket_id,description")>
<CFSET temp = QueryAddRow(myQuery)>
<CFSET QuerySetCell(myQuery,"ticket_id","1")>
<CFSET QuerySetCell(myQuery,"description","a;")>
<CFSET temp = QueryAddRow(myQuery)>
<CFSET QuerySetCell(myQuery,"ticket_id","2")>
<CFSET QuerySetCell(myQuery,"description","a;b")>
<CFFORM NAME="test" ACTION="#cgi.SCRIPT_NAME#">
<CFGRID NAME="testGrid" QUERY="myQuery" SELECTMODE="ROW" FORMAT="FLASH">
</CFGRID>
<CFINPUT TYPE="submit" NAME="submit">
</CFFORM>
I've tried different things and different platforms and different versions of
JRE all give me the same result.
Has this problem been solved yet?
Posts: n/a