Any chance that you're using SES URLs? We had a similar problem where a image src attribute was properly written causing the page to be run multiple times per 'request'.
If the page was /index.cfm/fuseaction/test.action, the image url was mistakenly written as "images/picture.gif", however the browser saw this as /index.cfm/fuseaction/test.action/images/picture.gif... Added the leading slash to the image calls and things worked fine. That was a really trying day... -- Jason Hill [EMAIL PROTECTED] http://weblinc.com ------------------- Quoting Tom Schreck <[EMAIL PROTECTED]>: > 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 was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================
