Hello cf-talk, On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS> I assume all of the fields from mensapparel down, and also saleinfo, are WS> number fields?
WS> will Well, the fields are yes/no in an Access. So, it looks like that is really a number field. 1 or 0? So single quotes? WS> -----Original Message----- WS> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] WS> Sent: 05 March 2002 17:47 WS> To: CF-Talk WS> Subject: can someone see a problem with this!!! WS> Hello everyone, WS> I must be missing something. I keep getting an error "data mismatch in WS> criteria". WS> But it looks right to me? What am I missing? I may be looking too WS> hard. WS> <cfquery name="UpdateRecord" datasource="os" dbtype="ODBC"> WS> UPDATE stores WS> SET storename='#Form.storename#', WS> map='#Form.map#', WS> description='#Form.description#', WS> salestart='#Form.salestart#', WS> saleend='#Form.saleend#', WS> saleinfo='#Form.saleinfo#', WS> wwwlink='#Form.wwwlink#', WS> mensapparel=#Form.mensapparel#, WS> womensapparel=#Form.womensapparel#, WS> maternity=#Form.maternity#, WS> AccessoriesJewelry=#Form.AccessoriesJewelry#, WS> ChildrenApparel=#Form.ChildrenApparel#, WS> FoodDrink=#Form.FoodDrink#, WS> toysgames=#Form.toysgames#, WS> HomeFurnishings=#Form.HomeFurnishings#, WS> music=#Form.music#, WS> Shoes=#Form.Shoes#, WS> saletitle='#Form.saletitle#' WS> WHERE storeID=#Variables.RecordID# WS> </cfquery> WS> Best regards, WS> Jeff Fongemie mailto:[EMAIL PROTECTED] WS> _____________________________________________________ WS> Composed on Tuesday, March 05, 2002, at 12:45:05 PM WS> ______________________________________________________________________ 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
