[SOLVED] RE: Entity Modeler - Strange Behaviour?
[SOLVED] RE: Entity Modeler - Strange Behaviour?
- Subject: [SOLVED] RE: Entity Modeler - Strange Behaviour?
- From: "Peter Thompson" <email@hidden>
- Date: Fri, 14 Mar 2008 12:17:23 +1300
- Thread-topic: [SOLVED] RE: Entity Modeler - Strange Behaviour?
|
Mike,
Yes your are correct. From the MySQL
manual:
A TIMESTAMP column is useful for recording the date and time of an
INSERT or
UPDATE
operation. By default, the first TIMESTAMP column in a table
is automatically set to the date and time of the most recent operation if you
do not assign it a value yourself. You can also set any TIMESTAMP column to the
current date and time by assigning it a NULL value. Variations on
automatic initialization and update properties are described in
Section 10.3.1.1, “TIMESTAMP
Properties”.
Learning something new everyday!
Many thanks for your help!
Cheers,
Peter
Are you sure "timestamp" is the correct external type? I seem
to recall that timestamp on mysql actually is a last modified stamp? hazy
memory, though.
ms
On Mar 13, 2008, at 7:09 PM, Mike Schrag wrote:
Begin forwarded message:
Date: March 13, 2008 6:49:07 PM
EDT
Subject: RE: Entity Modeler -
Strange Behaviour?
WO 5.3, MySQL, WoLips
2.0.0.4118.
Thanks,
Peter
When I
generate SQL this attribute gets the following SQL
generated:
`END_DATE`
timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
While I can
understand the "default CURRENT_TIMESTAMP" why does it add the "on update
CURRENT_TIMESTAMP"? Can this behaviour be switched
off? Entity Modeler doesn't generate
SQL, it uses EOF. What version of WO, what database, what
plugin?
ms _______________________________________________
Do
not post admin requests to the list. They will be ignored.
Webobjects-dev
mailing list (email@hidden)
Help/Unsubscribe/Update
your Subscription:
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden