I'm not going to answer the question about the best way to store your data.
But can we see the original query?
--K
-----Original Message-----
From: Chris Johnson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 27, 2000 3:10 PM
To: CF-Talk
Subject: DateTime Stamp Problem
I have a access database and I can't get the value of ,
'#CreateODBCDateTime(Now())#', in my Insert statement to work. I get the
error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression ''{ts '2000-10-27 14:49:50'}''.
The field type is text and a length of 100.
Is this the best way because long term I will search DateDiff of these
fields...
Any help?
-Chris
www.chris.com
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
