Hello Kathryn, On Tue, 5 Mar 2002, at 13:15:02 you carefully wrote: kwc> well the error points to the criteria field, so have you checked what kwc> #Variables.RecordID# is?
kwc> put kwc> <cfoutput>#Variables.RecordID#</cfoutput><cfabort> right before your kwc> query kwc> to check. kwc> is StoreID defined to be the datatype of #Variables.RecordID#? Yes, with the above test, the query is getting the storeid needed. Yes storeis is variables.recordid. For the fun of it, I just changed the query to a <cfupdate and it works fine with that. I don't completely trust the <cfupdate though and would rather use the insert query. I've been looking at this for too long I bet. I may leave the <cfupdate> and revisit this later. I must be looking too hard, and overlooking something obvious. kwc> -----Original Message----- kwc> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] kwc> Sent: Tuesday, March 05, 2002 1:09 PM kwc> To: CF-Talk kwc> Subject: Re: can someone see a problem with this!!! kwc> Hello cf-talk, kwc> On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote: WS>> I assume all of the fields from mensapparel down, and also kwc> saleinfo, are WS>> number fields? kwc> all of the fields from mensapparel down are yes/no boolean kwc> fields in Access. kwc> saletitle is text, salestart/end are dates. kwc> 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 kwc> 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> kwc> Best regards, kwc> Jeff Fongemie mailto:[EMAIL PROTECTED] kwc> ______________________________________________________________________ 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
