Jeff, Check your form to make sure that each set of radio buttons are named uniquely. Sometimes (and i bet we've all done this) I've copied/pasted a form element to add a new element and forgot to change the element's name. Your form element would then have a comma separating the two values, causing SQL to hiccup.
Just a guess. - j -----Original Message----- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:47 PM To: CF-Talk Subject: can someone see a problem with this!!! Hello everyone, I must be missing something. I keep getting an error "data mismatch in criteria". But it looks right to me? What am I missing? I may be looking too hard. <cfquery name="UpdateRecord" datasource="os" dbtype="ODBC"> UPDATE stores SET storename='#Form.storename#', map='#Form.map#', description='#Form.description#', salestart='#Form.salestart#', saleend='#Form.saleend#', saleinfo='#Form.saleinfo#', wwwlink='#Form.wwwlink#', mensapparel=#Form.mensapparel#, womensapparel=#Form.womensapparel#, maternity=#Form.maternity#, AccessoriesJewelry=#Form.AccessoriesJewelry#, ChildrenApparel=#Form.ChildrenApparel#, FoodDrink=#Form.FoodDrink#, toysgames=#Form.toysgames#, HomeFurnishings=#Form.HomeFurnishings#, music=#Form.music#, Shoes=#Form.Shoes#, saletitle='#Form.saletitle#' WHERE storeID=#Variables.RecordID# </cfquery> Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _____________________________________________________ Composed on Tuesday, March 05, 2002, at 12:45:05 PM ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
