[thelist] CF/ODBC/Access dates

[Oddur Snar Magnusson]

Is the thetableid field autonumber, if so leave it out of the query.
Also for Access use the #dd/mm/yyyy", just adjust the setting to the locale
on your server, that is the d/m/y order.

- oddur at mekkano.com

-----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 6: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 !