[thelist] CF/ODBC/Access dates
Oddur Snar Magnusson
oddur at mekkano.com
Fri Oct 13 06:09:05 CDT 2000
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 !
More information about the thelist
mailing list