You should be able to do it the same way with ibatis...did you try it? Did you get an error? Can you pass the error along?
Larry On Fri, Dec 11, 2009 at 1:42 AM, crmanoj <manojrathi...@gmail.com> wrote: > > I am developing a webapplication using Struts for which oracle is a backend. > For connectivity i am using iBatis. My application has a search page where > the user enters an id which inturn gets the data from DB. > The primary key for table which i am using is of type 'VARCHAR'. The values > for this primarykey field can contain characters like '_', '%' which are > wildcard characters. > > For example: > id name > user_1 Tom > user_2 Harry > > Suppose if a user wants to search for all rows which has '_' in their > primary key, how do i get this in iBatis. In a normal sql query in oracle, i > can use the keyword 'ESCAPE' for escaping the special characters. > For eg: > SELECT id,name FROM EMPLOYEE WHERE id LIKE '%\_%' ESCAPE '\' > > How do i handle this in iBatis?. > > I am using the method 'queryforlist' in java to get the data. > In SqlMap, i am using <select> tag. > > Thanks in Advance. > -- > View this message in context: > http://old.nabble.com/Search-for-character-%27_%27%2C-%27-%27-wildcard-characters-using-ibatis-tp26740551p26740551.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
