Tom, could you try calling your stored proc from a non cf page and see what happens....i know the tag I wrote works as expected outside of a fusebox app....
> -----Original Message----- > From: Brian Kotek [mailto:[EMAIL PROTECTED]] > Sent: 17 May 2002 21:54 > To: [EMAIL PROTECTED] > Subject: RE: HELP: Strange CF Problem > > > Not to disrupt this very interesting thread, but this is > probably better > suited to the FBCommunity Topica list. I think we're trying to keep > this list devoted specifically to Fusebox-related discussions. > > Thanks, > > Brian > > > Shannon Hicks wrote: > > Not that this will solve your problem, but it will speed up > your page: > > > > Instead of your code use this: > > > > <cfquery name="qryGetHitCount" datasource="#request.dsn#"> > > UPDATE tblContent SET numHitCount = numHitCount + 1 WHERE > > numContentID=#Request.stAttributes.numContentID# > > </cfquery> > > > > One query is (almost) always better than 2. > > > > Shan > > > > > > -----Original Message----- > > From: Tom Schreck [mailto:[EMAIL PROTECTED]] > > Sent: Friday, May 17, 2002 3:45 PM > > To: [EMAIL PROTECTED] > > Subject: RE: HELP: Strange CF Problem > > > > > > No, I'm on the dev environment and nobody's there except 1 other > > developer and he was in my office scratching his head. I > do have it in > > a transaction. I heard of situations where code would run 2 times > > inside a custom tag. But I moved it to inside the calling > page. No > > cfmodules. No custom tags. Straight sql. > > > > Thanks - > > > > Tom Schreck > > 817-252-4900 > > [EMAIL PROTECTED] > > > > I have not failed. I've found 10,000 ways that won't work. > > > > - Thomas Edison > > > > -----Original Message----- > > From: Timothy Heald [mailto:[EMAIL PROTECTED]] > > Sent: Friday, May 17, 2002 3:39 PM > > To: [EMAIL PROTECTED] > > Subject: RE: HELP: Strange CF Problem > > > > Is it in a transaction? Is it possible that you are having enough > > traffic that it is actually getting two requests at a time? > > > > Tim Heald > > ACP/CCFD :) > > Application Development > > www.schoollink.net > > -----Original Message----- > > From: Tom Schreck [mailto:[EMAIL PROTECTED]] > > Sent: Friday, May 17, 2002 4:33 PM > > To: [EMAIL PROTECTED] > > Subject: RE: HELP: Strange CF Problem > > I forgot to mention that after my update I did subsequent select > > statements to retrieve the new numHitCOunt and each time it > would return > > the correct value. I check the database and it would have > the incorrect > > value. I did a subsequent query in OnRequestEnd even. > Tried stopping > > and restarting CF Server. No Luck. > > > > I was thinking a trigger, however, I've opened the original stored > > proc > > in query analyzer, passed the content id and it incremented > by 1. Looks > > like a Cold Fusion error. > > > > Thanks - > > > > Tom Schreck > > 817-252-4900 > > [EMAIL PROTECTED] > > > > I have not failed. I've found 10,000 ways that won't work. > > > > - Thomas Edison > > > > -----Original Message----- > > From: Schreck, Tom > > Sent: Friday, May 17, 2002 3:27 PM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: HELP: Strange CF Problem > > > > 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/help/unsub.html 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 > > ==^================================================================ > > > > > > > > > > --- > > > > _____________________________________________________________________ > This message has been checked for all known viruses by UUNET > delivered > through the MessageLabs Virus Control Centre. For further > information visit http://www.uk.uu.net/products/security/virus/ > _____________________________________________________________________ This message has been checked for all known viruses by UUNET delivered through the MessageLabs Virus Control Centre. For further information visit http://www.uk.uu.net/products/security/virus/ ==^================================================================ 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 ==^================================================================
