Depends whether you want to use the db server value or the web server value for the date. The db server may be significantly different. Maybe CreateODBCDateTime(now()) might be more applicable? Depends on the requirement. As to trigger or default value - using a default value will still allow you to overwrite if needed, thus you can use either the getdate() or CF now() function. If you use a trigger it will always use getdate(). Again depends on the requirement.
> Heya all, What might be a purely academic question here... if you > want a record to automatically have a 'date created' field. Is it > best practise to achieve this by giving the 'dateCreated' field a > default value of getdate(), or write a trigger on INSERT that sets > the 'dateCreated' field. Is there any reason to do one or the other? > bye! --- > 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/ --- 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/
