My recommendation is to make sure you DB Server has a correct date/time setting and use (in SQL at least) the getdate() function as the default.
We use this method because we have 6 CFMX servers talking to the DB. And it is easier to keep the DB Server date/time as the reference.
I dont see why you would use an INSERT trigger to set it.
In either case, the only way to get CFMX to set that date is to include it in the INSERT statement in your CFQUERY (because the DB server is not going to be able to get the CFMX now() value).
Regards,
Gary
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
