Hello cf-talk, On Tue, 5 Mar 2002, at 13:12:20 you carefully wrote: JC> What are the values contained in those form fields? (I'm Assuming they are JC> check boxes)
JC> - j The values are 1 or 0, they are radio buttons. JC> -----Original Message----- JC> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] JC> Sent: Tuesday, March 05, 2002 1:09 PM JC> To: CF-Talk JC> Subject: Re: can someone see a problem with this!!! JC> Hello cf-talk, JC> 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? JC> all of the fields from mensapparel down are yes/no boolean JC> fields in Access. JC> saletitle is text, salestart/end are dates. JC> 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> JC> Best regards, JC> Jeff Fongemie mailto:[EMAIL PROTECTED] JC> ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
