cfgrid and semicolon bug

Posted: 04-02-2007, 08:37 PM
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?

Reply With Quote

Responses to "cfgrid and semicolon bug"

tzimmerman
Guest
Posts: n/a
 
Re: cfgrid and semicolon bug
Posted: 04-03-2007, 02:33 PM
Bug 60478 was opened for this problem. It is going to be fixed in the next release of ColdFusion. I can't give you the release date at this time.

Ted Zimmerman
Reply With Quote
Whatisvalid
Guest
Posts: n/a
 
Re: cfgrid and semicolon bug
Posted: 10-02-2007, 06:01 PM
I'm looking at ColdFusion MX 7.02 Cumulative Hot Fix 3 KB402465 and ID Number
60478 is not listed as being fixed. There is also no mention of this bug in
TechNote b9c2d61c which is an update of CFForm controls. When can we expect a
fix and check on the status? I have over 100 pages using CFGrid, and 10-15
pages that fail to work due to semicolons.

Reply With Quote
Whatisvalid
Guest
Posts: n/a
 
Re: cfgrid and semicolon bug
Posted: 10-02-2007, 06:46 PM
:disgust;

I tried to open a presales tech support case for ColdFusion 8 to see if this
issue was solved. Since I do not own 8 yet, I was told to go to this forum and
wait for a response, or purchase ColdFusion 8 AND a $499 tech support case to
have the issue answered. This isn't a very nice way to treat loyal customers!

Reply With Quote
morcutt
Guest
Posts: n/a
 
Re: cfgrid and semicolon bug
Posted: 09-29-2008, 11:32 PM
Anyone find a solution for this? We're running CF 8 Enterprise and can't get CFGRID to render content from database fields where semicolons are present.
Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic CFGrid hhr_jb Coldfusion Flash Integration 0 02-28-2006 09:59 PM
Flash CFGRID LabDesigns Coldfusion Flash Integration 0 09-20-2005 09:24 PM
cfgrid Chikowski Coldfusion Flash Integration 10 07-22-2005 06:49 PM
CFGRID & Checkbox ArtNirvana Macromedia ColdFusion 3 02-17-2005 02:45 AM
cfgrid links t0ad 99 Macromedia ColdFusion 1 02-16-2005 04:51 PM