I believe you are correct. I used wildcards and it worked. Tom
-----Original Message----- From: Sgarlata Matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:38 PM To: Apache Torque Users List Subject: Re: How to do when i want to query like "select * from book where book.name like 'TCP' "? Try this: Criteria crit2 = new Criteria(); crit2.add("BOOK.TITLE", (Object)"%TCP%", Criteria.LIKE); I think Torque only puts in LIKE if you actually use wildcards in your query. Otherwise Torque uses =. ----- Original Message ----- From: "sailorhero" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 2:33 PM Subject: Re: How to do when i want to query like "select * from book where book.name like 'TCP' "? > I think I find a bug. > I used the torque 3.0.2. > when I used the second method ,but the result of query is wrong. > I open the log4j in debug mode. > I find the SQL query is wrong . > code: > Criteria crit2 = new Criteria(); > crit2.add("BOOK.TITLE", (Object)"TCP", Criteria.LIKE); > > List results = BookPeer.doSelect(crit2); > printBooklist(results); > The log4j is like this. > DEBUG [main] util.BasePeer (createQueryString:994) - SELECT book.BOOK_ID, book.TITLE, book.ISBN, book.TIME, book.PUBLISHER_ID, book.AUTHOR_ID FROM book, BOOK WHERE BOOK.TITLE = 'TCP' > DEBUG [main] util.BasePeer (executeQuery:1532) - Elapsed time=0 ms --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
