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.
Type: | Technote |
---|---|
Issue Number: | FDS-114 |
Components: | Breakpoints |
Environment: | |
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 |