RE: [Reactor for CF] isLike on integer column

[Chris Blackwell]

Doug,   What database are you using?  There have been issues recently with mysql reporting incorrect field lengths causing reactor to set an incorrect maxlength attribute in cfqueryparam, if you’re on mysql upgrade to the most recent version.   Btw. LIKE does work on integer columns in mysql   Cheers, Chris   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Arthur Sent: 12 September 2006 05:21 To: reactor@reactorframework.com Subject: [Reactor for CF] isLike on integer column   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 reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --