two things:
First, "like" is used for character matching, not matching digits. "=" can be used with character or numerics. My guess is most databases would have problems with using like on a numeric field even if there wasn't error with the MAXLENGTH.
Second, do you have the latest version of reactor? The fix to http://trac.reactorframework.org/reactor/ticket/49 might take care of the maxlength error.
Beth
On 9/12/06, Doug Arthur <[EMAIL PROTECTED]> wrote:
When I do an isLike on column of integer datatype, I get the following error:"The cause of this output exception was that: coldfusion.tagext.sql.QueryParamTag$InvalidDataException: Invalid data %759698% value exceeds MAXLENGTH setting 2.."When I use isEqual, then it works. Any ideas on isLike?Thanks!- Doug
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
