apostrephe somewhere On Tue, 5 Mar 2002, Jeff Fongemie wrote:
> 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 > ______________________________________________________________________ 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
