See my other posting on this topic for my full conclusion but... I tried this below and you can use it or you don't have to. It works either way, once you get the other syntax issues ironed out.
Thanks for posting... Bruce ----- Original Message ----- From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 11:22 AM Subject: RE: Access Db Query Date Syntax > 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
