ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Campbell" <rrc...@gmail.com>
Subject Re: <iterate> used to work, now fails
Date Thu, 29 Jun 2006 13:12:30 GMT
 I figured out what it was. I changed

UPPER(sponsor_name) LIKE #value[]#

to

UPPER(sponsor_name) LIKE '%'||#value[]#||'%'

And took out the Java code that manually added the "'%'..etc

This is better form anything. What's weird, however, is that the first
method worked just fine before.. who knows, I'm just glad it's fixed.

Mime
View raw message