Question
cfgrid and semicolon bug
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?
<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?
AdChoices