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.
|Server:||Resin, ColdFusion 8, Railo, ColdFusion 6, Jetty, ColdFusion 7|
|Platform:||Solaris, MacOS, Linux, Windows 2003, Windows Vista, Windows 2000, Windows x64, Windows XP|