You can view the issue detail at the following URL:
<http://nagoya.apache.org/scarab/issues/id/TRQS24>
Type : Defect
Issue Id : TRQS24
Reported by: Rags Srinivasan
rags - ([EMAIL PROTECTED])
Details:
Summary: addDate() gives SQL exception with MySQL
Description: I am using Torque3.0b4, with MySQL database. I was trying to
doSelect() entries from a table that are less than certain date.
But i get a SQL error, it appears the SQL statement is built by
calling toString() on GregorianCalendar() instead of using
a DateFormat.
Here is the code fragment
// query from games table
criteria.anDated(GamePeer.DATE, year, month,date,
Criteria.GREATER_THAN);
Here is the error output:
2002-10-13 16:44:02,239 [Thread-6] DEBUG org.apache.torque.util.BasePeer - SELECT
games.WEEKNO, games.GAMENO, games.DATE, games.VISITOR, games.HOME,
games.VISITOR_SCORE, games.HOME_SCORE FROM games WHERE
games.DATE<=java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="US/Mountain",offset=-25200000,dstSavings=3600000,useDaylight=true,transitions=157,lastRule=java.util.SimpleTimeZone[id=US/Mountain,offset=-25200000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=3,startDay=1,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2002,MONTH=9,WEEK_OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=21,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OFFSET=?,DST_OFFSET=?]
ORDER BY games.GAMENO
Status: New
Database: MySQL
Operating system: Linux
Priority: Undecided
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
