Is the PlayerNumber field a numeric data type? If it is, you don't want to use any quotes.
Example: WHERE PlayerNumber = #FORM.PlayerNumber# -----Original Message----- From: Frank Velazquez [mailto:[EMAIL PROTECTED] Sent: Friday, February 22, 2008 3:20 PM To: CF-Newbie Subject: More mismatch Data...( u_u)! Ok, I'm getting the following error: Error Executing Database Query. Data type mismatch in criteria expression. The error occurred in C:\CFusionMX7\wwwroot\LOCALuberHunt\wwwroot\answersTEST_2.cfm: line 114 112 : HunterIP= '#CGI.REMOTE_ADDR#', 113 : HunterBrsr= '#CGI.HTTP_USER_AGENT#' 114 : WHERE PlayerNumber = '#FORM.PlayerNumber#' 115 : </cfquery> 116 : ------------------------------------------------------------------------ -------- SQL UPDATE DailyHntr SET HunterName = 'andres Velazquez', HunterAddress = '10500 sw 44 ter', HunterCity = 'miami', HunterState = 'florida', HunterZip = '33165', MailListJoin= 'Yes|No', HunterEmail= '[EMAIL PROTECTED]', HunterPhone= '7863957224', HunterIP= '127.0.0.1', HunterBrsr= 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; ..NET CLR 1.1.4322)' WHERE PlayerNumber = '1203711046875' DATASOURCE Hunters VENDORERRORCODE 3079 SQLSTATE Resources: ==================== I've tryed the only two ways I know how to fix this issue which is: - '#FORM.PlayerNumber#' <---- With Quotes - #FORM.PlayerNumber# <---- Without Quotes The DATA TYPE in my Database (In PlaverNumber) is set to be TEXT not a string, even though it receives a number. This was working perfectly yesterday, and today all of a sudden doesn't want to work anymore. Any of you know what this could be? Here is the link to the site I am working on: http://uberhunt.com/answersTEST_2.cfm?HunterId=1203711882525 Try filling out the form at the end and when you submit it is when the error occurs I have the same update query (WHERE PlayerNumber = '#FORM.PlayerNumber#') in other parts of my site and in works fine, but it only crashes here. T.I.A ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3334 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
