Yes, you have problems with your query. ###Form.datepart# #Form.timepart###, This will not work at all.
What do form.datepart and form.timepart look like? You may need to break these into pieces and create a proper datetime object in CF before you submit them to the database. - Matt Small -----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] ------------------------------------------------- ______________________________________________________________________ Get Your Own 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=coldfusionb 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
