createODBCdateTime(dateVal) is correct...
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 11:11 AM
To: CF-Talk
Subject: RE: Access Db Query Date Syntax
Are you using ODBC or OLEDB?
If your using ODBC just use CreateODBCdatetime(datetime)
______________________
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-----Original Message-----
From: Bruce Holm [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 2:07 PM
To: CF-Talk
Subject: Access Db Query Date Syntax
I have more trouble with trying to write INSERT and UPDATE querys for
an
Access Db.
I need help with what is wrong here.
My insert query looks like this:
<cfoutput>
<cfquery name="qInsertClass" datasource="abb"> INSERT INTO
Classes ( Status, Date, Class, ShortName,
Credit, Location, Description ) VALUES (
'#FORM.Status#', ###Form.datepart# #Form.timepart###,
'#FORM.Class#', '#FORM.ShortName#', #FORM.Credit#,
'#Form.Location#', '#FORM.Description#' ) </cfquery>
</cfoutput>
The ONLY line that gives me problems is:
###Form.date###,
THe table column being inserted into is an Access 97 database table
column defined as Date/Time of General format. I have also tried
separating the date and time elements into separate form fields and
trying:
###Form.datepart# #Form.timepart###,
All I get is a syntax error.
Hosting server has been set to not give more details than this.
I take the date insert line out and the rest goes in just fine.
THis is like the third page I've created using Access db and inserting
dates and every time I have problems. I've gotten the others to work
but this one, although copied and modified slightly from the others,
does not work.
Your help would be appreciated!
-------------------------------------------------
Bruce Holm - Web Programmer
Lattice Semiconductor Corp.
[EMAIL PROTECTED]
-------------------------------------------------
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
