What are the values contained in those form fields? (I'm Assuming they are check boxes)
- j -----Original Message----- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 1:09 PM To: CF-Talk Subject: Re: can someone see a problem with this!!! 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? all of the fields from mensapparel down are yes/no boolean fields in Access. saletitle is text, salestart/end are dates. I don't get it, it still looks right. 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> Best regards, Jeff Fongemie mailto:[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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists