Yes I'd check that format. > '#start_time#''#start_ampm#' For starters you would want something more like '#start_time# #start_ampm#' (note the 1 set of single quotes). That said it may still not be correct. I'd look into using the CreatODBCDateFormat().....it will solve your problems providing you are passing it valid date/time data.
Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Phillip Broussard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 1:46 PM Subject: RE: access query? > I would take a look at this > '#start_time#''#start_ampm#', > It doesn't look like a correct date/time fromat to me but I could be > wrong. > > Phillip > > > -----Original Message----- > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 25, 2002 1:04 PM > > To: CF-Talk > > Subject: access query? > > > > I have not messes with access before, and I am getting the following > > error. > > > > ODBC Error Code = 22005 (Error in assignment) > > > > > > [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in > criteria > > expression. > > > > > > > > Here is my query > > > > > > > > <CFQUERY DATASOURCE="iec" NAME="insert_classes"> > > INSERT INTO classes ( class_title, (text) > > class_location, (text) > > start_date, (date/time) > > cost, (currency) > > start_time, (date/time) > > end_time, (date/time) > > is_current ) (text) > > > > VALUES ( '#title#', > > '#location#', > > #date#, > > #cost#, > > '#start_time#''#start_ampm#', > > '#end_time#''#end_ampm#', > > '#is_current#' ) > > </CFQUERY> > > > > > > "Success is a journey, not a destination!!" > > > > > > > > Doug Brown > > > > > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists