[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.