Hey,
I need to be able to filter datetime fields with a SQL statement like this: SELECT dt FROM table WHERE dt LIKE "2006-%" Or something of that nature. I used the where.isLike() statement and loaded the value 2006-11 (because is like will wrap %'s around them) and I get this error: Message: The cause of this output exception was that: coldfusion.tagext.sql.QueryParamTag$InvalidDataException: Invalid data %2006-11% value exceeds MAXLENGTH setting 2.. If you check the code in the query it creates it sets the queryparam to maxlength 2. is this a bug? Or what am I doing wrong? Thanks! - Derek -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
