Try changing the name of the form variable to something other than 'date.'
I think that is a reserved word.
Kevin
>>> [EMAIL PROTECTED] 02/01/02 11:06AM >>>
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]
-------------------------------------------------
______________________________________________________________________
Why Share?
Dedicated Win 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=coldfusionc
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
