I'm not sure but I'd guess the later. The hosting service doesn't say ho w they've configured it. It's just probably the standard Access Db server.
I do know that this function isn't necessary for dates to be entered. Re ad my full conclusion in my other posting minutes ago. Thanks for responding. Bruce ----- Original Message ----- From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 11:10 AM 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 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] > ------------------------------------------------- > > > > ______________________________________________________________________ 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
