Thanks, that is what we are doing now for a work around. I just thought if it was a bug it would be nice to let the author know.
Belinda On Fri, 11 Oct 2002, Gaul, Ken wrote: > Can't comment on limitations of DB2 or DBD::DB2 but lets face it you could > do the lcase bit on the bind parameter before the execute using perl string > functions. Then the problem goes away. > > Ken. > > -----Original Message----- > From: Belinda M. Giardine [mailto:[EMAIL PROTECTED]] > Sent: 09 October 2002 20:21 > To: [EMAIL PROTECTED] > Subject: problem with DB2 and LIKE LCASE (?) > > > When we run a query with syntax like > SELECT foo FROM bar WHERE (lower(foo) LIKE lower(?)) > from DBI we get the error > DBD::DB2::db prepare failed: [IBM][CLI Driver][DB2/LINUX] SQL0418N A > statement contains a use of a parameter marker that is not > valid. SQLSTATE=42610 > > The query without the LCASE works > SELECT foo FROM bar WHERE (lower(foo) LIKE ?). > > Is this a limitation of DB2 (it works in Oracle) or is it an error > in DBD::DB2? > > Thanks, > Belinda >
