I use addDate() and andDate() to query some line . first: I want to know where is the diffirent between the two methods.
When i use twice the addDate() to a field ,just the last is used ,Why? how to create a Criteria which like "book.TIME<='20030801000000' and book.TIME>='20030801000000'"? example code: Criteria crit1 = new Criteria(); crit1.addDate(BookPeer.TIME,2003,7,1,Criteria.GREATER_EQUAL); crit1.andDate(BookPeer.TIME,2003,7,1,Criteria.LESS_EQUAL); results = BookPeer.doSelect(crit1); but i find just the last method is used. log4j output: DEBUG [main] util.BasePeer (createQueryString:994) - SELECT book.BOOK_ID, book.TITLE, book.ISBN, book.TIME, book.PUBLISHER_ID, book.AUTHOR_ID FROM book WHERE book.TIME<='20030801000000' DEBUG [main] util.BasePeer (executeQuery:1532) - Elapsed time=10 ms Second: when i use andDate(),there is error code: crit1.andDate(BookPeer.TIME,2003,7,1,Criteria.LESS_EQUAL); results = BookPeer.doSelect(crit1); log4j output: DEBUG [main] util.BasePeer (createQueryString:994) - SELECT book.BOOK_ID, book.TITLE, book.ISBN, book.TIME, book.PUBLISHER_ID, book.AUTHOR_ID FROM book WHERE (book.TIME>='20030801000000' AND book.TIME<=java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Shanghai",offset=28800000,dstSavings=0,useDaylight=false,transitions=19,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2003,MONTH=7,WEEK_OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=1,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OFFSET=?,DST_OFFSET=?]) java.sql.SQLException: Syntax error or access violation, message from server: "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 '[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,z" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928) at com.mysql.jdbc.Connection.execSQL(Connection.java:1871) at com.mysql.jdbc.Connection.execSQL(Connection.java:1805) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1143) at com.workingdogs.village.QueryDataSet.<init>(Unknown Source) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1531) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1360) at com.kazmier.om.BaseBookPeer.doSelectVillageRecords(BaseBookPeer.java:385) at com.kazmier.om.BaseBookPeer.doSelectVillageRecords(BaseBookPeer.java:353) at com.kazmier.om.BaseBookPeer.doSelect(BaseBookPeer.java:321) at com.kazmier.mytest.main(mytest.java:60) rethrown as org.apache.torque.TorqueException: Syntax error or access violation, message from server: "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 '[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,z" at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1541) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1360) at com.kazmier.om.BaseBookPeer.doSelectVillageRecords(BaseBookPeer.java:385) at com.kazmier.om.BaseBookPeer.doSelectVillageRecords(BaseBookPeer.java:353) at com.kazmier.om.BaseBookPeer.doSelect(BaseBookPeer.java:321) at com.kazmier.mytest.main(mytest.java:60) Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "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 '[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,z" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928) at com.mysql.jdbc.Connection.execSQL(Connection.java:1871) at com.mysql.jdbc.Connection.execSQL(Connection.java:1805) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1143) at com.workingdogs.village.QueryDataSet.<init>(Unknown Source) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1531) ... 5 more rethrown as org.apache.torque.TorqueException: Syntax error or access violation, message from server: "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 '[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,z" at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1373) at com.kazmier.om.BaseBookPeer.doSelectVillageRecords(BaseBookPeer.java:385) at com.kazmier.om.BaseBookPeer.doSelectVillageRecords(BaseBookPeer.java:353) at com.kazmier.om.BaseBookPeer.doSelect(BaseBookPeer.java:321) at com.kazmier.mytest.main(mytest.java:60) Caused by: org.apache.torque.TorqueException: Syntax error or access violation, message from server: "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 '[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,z" at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1541) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1360) ... 4 more Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "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 '[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,z" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928) at com.mysql.jdbc.Connection.execSQL(Connection.java:1871) at com.mysql.jdbc.Connection.execSQL(Connection.java:1805) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1143) at com.workingdogs.village.QueryDataSet.<init>(Unknown Source) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1531) ... 5 more
