You have made the following statement
"Better yet, if you've got a field which, when a record is inserted, always
is filled with the current date/time, MAKE THAT A DEFAULT IN YOUR DATA DESIGN;
that way, you move the responsibility for managing that to the
database itself."
Can u please explain the line in caps,sorry iI am not able to figure it out.
thank you
Denny
Cut that out!
Seriously, you can avoid all this by using the native SQL functions:
INSERT INTO some_table (date_column)
VALUES (GETDATE())
Better yet, if you've got a field which, when a record is inserted, always
is filled with the current date/time, make that a default in your data
design; that way, you move the responsibility for managing that to the
database itself.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
