Are: 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#,
All numbers? If not then they should have '#form.whatever#' around... And any date/numeric fields should have none... J -----Original Message----- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 17:47 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
