CreateODBDateTime will put in ' inside the {ts...} what we are talking
about is the ones on the outside of the {ts...}
Micahel
At 03:58 PM 10/27/00, you wrote:
>CreateODBCDateTime puts the apostrophes by itself. That is the prob.
>
><Jaime/>
>
>
> > -----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]
Michael Slatoff
[www.BOXoFUSES.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]