[thelist] CF/ODBC/Access dates

Seth Bienek seth at sethbienek.com
Thu Oct 12 22:09:12 CDT 2000


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 at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Oliver Lineham
> Sent: Thursday, October 12, 2000 8:56 PM
> To: thelist at 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 at 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 ! 
> 





More information about the thelist mailing list