[FDS-114] Matching column fields and conditions on breakpoints; blank space required


Comparisons between database strings and CFML strings

Conditional breakpoint expressions are pure CFML code, therefore when you use a query column that has a fixed size, for example nchar(10), the returned string is buffered with spaces to fill the length of 10, i.e. “James “. This means that when a comparison is made; qry.id eq “James”, this will return false and the breakpoint will not fire.

The same problem arises in CFML, one solution is to use the Trim or RTrim functions.

Issue Details

Type: Technote
Issue Number: FDS-114
Components: Breakpoints
Resolution: Fixed
Added: 06/08/2009 11:52:53
Affects Version: 3.0
Fixed Version: 3.0
Server: Resin, ColdFusion 8, Railo, ColdFusion 6, Jetty, ColdFusion 7
Platform: Solaris, MacOS, Linux, Windows 2003, Windows Vista, Windows 2000, Windows x64, Windows XP
Related Issues: None

Comments are closed.