I suggested the same thing, though I keep forgetting Sam messes with the reply-to header. I guess its my fault for not being vigilant, but I do find that very annoying.
john mcnally On Thu, 2002-05-16 at 15:29, James A. Hillyerd wrote: > What is with the MySQL TIMESTAMP type, does it get changed any time the > row is updated? If so, then perhaps Torque should use DATETIME instead > of TIMESTAMP for the TIMESTAMP column type (on MySQL)? When I use a > TIMESTAMP in Torque, I don't expect it to change unless I explicitly set > it. > > -james > > > > On Thu, 2002-05-16 at 13:48, Sam Joseph wrote: > > John McNally wrote: > > > > >I use DATETIME and torque. What's the problem you are having with it? > > > > > > > > I was under the impression that the database.dtd does not support > > DATETIME as a column name > > > > >http://cvs.apache.org/viewcvs/jakarta-turbine-torque/src/dtd/database.dtd?rev=1.12&content-type=text/vnd.viewcvs-markup > > > > i.e. > > > > type > > ( > > BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT > > | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | > > LONGVARCHAR > > | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | > > LONGVARBINARY > > | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY > > | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR > > | DOUBLE > > ) "VARCHAR" > > > > does not include the option "DATETIME". If I want to get a DATETIME > > column in MySQL I select DATE as my column type in my schema. This by > > itself would seem to require a change, i.e. what if I want a DATE column > > in MySQL? it seems I have to way to request it. This implies that the > > DATE, TIME, TIMSTAMP, and DATETIME column types should all be supported > > at the dtd level. > > > > Now there is no DATETIME column type in postgreSQL, so DATE just stays > > as DATE. My application cannot use TIMESTAMP in MySQL meaning that I > > have to change my schema in order to get it to work with postgre. I > > want to be able to release a single schema that people will be able to > > use to create the appropriate database tables in both MySQL and Postgre > > > > In order to do this I think the database dtd should be changed to > > include a DATETIME option which would map onto "DATETIME" in MySQL and > > "TIMESTAMP" in PostGreSQL, and the DATE /TIME column types would be > > mapped onto DATE/TIME in both databases. > > > > I was hoping to hear about which parts of the code would require changes > > to support this. > > > > Thanks in advance. > > > > CHEERS> SAM > > > > > > -- > > To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> > > > > > -- > [] James A. Hillyerd <[EMAIL PROTECTED]> - Java Software Engineer > [] PGP 1024D/D31BC40D F87B 7906 C0DA 32E8 B8F6 DE23 FBF6 4712 D31B C40D > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
