Oh! those! you don't need them.
{ts is an ODBC escape secuence that makes the access ODBC driver to properly
format the date to whatever they need to. there is {fn, {sp, etc.
In fact, there is a {fn Now()} that you could use. I deal with access and
oracle and SQL server so I use only escape secuences OR CF functions.
INSERT INTO myTable (theDate) values ({fn NOW()})
see:
http://msdn.microsoft.com/library/psdk/dasdk/odch34df.htm
and then click on "show toc" for the escape secuence definitions in ODBC.
<Jaime/>
> -----Original Message-----
> From: [BOXoFUSES] Michael Slatoff [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 27, 2000 4:16 PM
> To: CF-Talk
> Subject: RE: DateTime Stamp Problem
>
>
> 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
> > >
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
