thank you! IN ?state? WORKS!
where in the docs does it explain this issue? thanks again Poitras Christian wrote: > > Make a List of states (or an array) and use the iterate tag (see the > documentation). > > Another possibility is to use > <isNotNull prepend="AND" property="state"> > LG.state IN ?state? > </isNotNull> > But I don't recommend this in your case. You should really use the > iterate tag. > > Christian > > -----Original Message----- > From: xianwinwin [mailto:[EMAIL PROTECTED] > Sent: Monday, 16 April 2007 17:26 > To: [email protected] > Subject: what is the correct SQL for IN ? > > > Hi there, > > I wonder how to implement this query in ibatis as it gives me an error > message. > > query: ..... AND LG.state IN ('ny', 'bj') (in plain sql) > > in ibatis: > > <isNotNull prepend="AND" property="state"> > LG.state IN #state:VARCHAR# > </isNotNull> > > > error: You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near > ''(\'ny\', \'nj\')' > > the state value is: "('ny', 'nj')" > > thanks > -- > View this message in context: > http://www.nabble.com/what-is-the-correct-SQL-for-IN---tf3587326.html#a1 > 0024994 > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > -- View this message in context: http://www.nabble.com/what-is-the-correct-SQL-for-IN---tf3587326.html#a10025815 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
