Sounds silly, but have you tried stopping and restarting CFServer? If in doubt, reboot! ;-)
> > I have a stored procedure being called via cfmodule that queries a > > specific record, retrieves its hit count, then increments the hitcount > > by 1. We noticed the hit count being updated by 2. I figured > > something's wrong with the stored procedure. I replaced the stored proc > > call in the cfmodule call with actual sql query to retrieve the hit > > count then a second query to update hitcount by 1. Record is still > > getting updated by 2. So I figure somehow the cfmodule is getting > > called twice. So I then remove the call to the cfmodule and replace it > > with a query to retrieve the hitcount and a second query to increment > > the hitcount by 1. Record is still getting updated by 2. So I figure > > there's a call somewhere else that's causing the record to be updated. > > I removed the 2 queries to update hitcount all together. Re run the > > page and hit count does NOT get updated. So it's pretty evident that > > the 1 query is updating record by 2 versus 1. > > > > Here's my code: > > > > <cfquery name="qryGetHitCount" datasource="#request.dsn#"> > > SELECT numHitCount FROM tblContent WHERE > > numContentID=#Request.stAttributes.numContentID# > > </cfquery> > > > > <cfset tmpCount = qryGetHitCount.numHitCount+1> > > > > <cfquery name="qryGetHitCount" datasource="#Request.dsn#"> > > UPDATE tblContent > > SET numHitCount = #tmpCount# > > WHERE numContentID = #Request.stAttributes.numContentID# > > </cfquery> > > > > I've tried putting the calculation inside the second query versus using > > a variable. I've tried <cfabort> right after update query and it still > > updates by 2. I'm using SQL Server 2000. I've change the data type > > from tinyInt to Int to numeric and it all gets updated by 2. Out of > > desperation, I change from +1 to +.5 and no luck :-(. This phenomenon > > Is occurring on our Production and Development box. > > > > Interesting enough, I use the same procedure for a different site and it > > updates the recordcount by 1. HELP > > > > Thanks - > > > > Tom Schreck > > 817-252-4900 > > [EMAIL PROTECTED] > > > > I have not failed. I've found 10,000 ways that won't work. > > > > - Thomas Edison > > > > > > ------------------------------------------------------------------------- > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: www.mailshield.com > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
