[thelist] CF/ODBC/Access dates

[Oliver Lineham]

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