I don't remember anyone mentioning CF debugging information ... have you switched on the query info on the debug ? (You may need to run the pure SQL version, not the stored procedure, for this to help).
That should tell you for sure if the query's being called once or twice. If you see a single call then the problem's deep in CFAS, ODBC or your database. If you see two calls the likely culprit is either your code or the fusebox core files. Like John, I've seen unexpexted effects like code being called twice due to fusebox, in my case usually down to me not thinking through the consequences of a cfmodule call (via the home circuit) re-invoking the FB core files etc. HTH, Andy. Tom Schreck wrote: > 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 ==^================================================================
