See my other post...this does work. I have code that uses this code. It turned out to be the Access db column was defined to be 'date' which apparently is a reserved word of some sort. See my other post.
Thanks for your suggestion anyway. Bruce ----- Original Message ----- From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 11:24 AM Subject: RE: Access Db Query Date Syntax > 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 befor e > 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 a n > > 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
