[thelist] CF/ODBC/Access dates

Hi Ol,

Is "date" a valid fieldname?  I think it's an SQL reserved word.  You should probably use a more decriptive field name anyway.

If that doesn't get you squared away, then check your access table to make sure the field type is "date" and not something else.

HTH,

Seth

> -----Original Message-----
> From: thelist-admin@lists.evolt.org
> [mailto:thelist-admin@lists.evolt.org]On Behalf Of Oliver Lineham
> Sent: Thursday, October 12, 2000 8:56 PM
> To: thelist@lists.evolt.org
> Subject: [thelist] CF/ODBC/Access dates
> 
> 
> hi,
> 
> i'm having trouble inserting dates into an Access database via ODBC with CF.
> 
> the query basically is (for example):
> 
> INSERT INTO Thetable(thetableid, date) VALUES(6, {d '2000-10-13'})
> 
> [obviously the 6 actually comes from cf_max_id, and the ODBC date was 
> generated by CreateODBCDate()]
> 
> what am I doing wrong?
> 
> </ol>
> 
> ____________________________________________________
>      v i b e   m e d i a    http://www.vibe.co.nz/
>   po box 10-492              wellington, new zealand
>   phone +64 21 210-7845         oliver@lineham.co.nz
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>