SQL update not executing?
OK, no response on the question earlier, but maybe someone has seen this or can help me figure out where to look... I have a page which every once in a while will execute fully, but there is an update statement that does not update the database even though I see the query in my debug. Here is a snip from the debug: (Records=0, Time=100ms) SQL = UPDATE banners WITH (ROWLOCK) SET views = views + 1, next_rotation = next_rotation + 16 WHERE adid = 2 The debug says it happened , however when I go look at the db right after this statement and the next_rotation field hasn't budged! This does not happen every time, however it always does happen eventually. It only happens however, when I am stressing the application (which is a banner app...) with a simple 8 frame meta refresh page i did up. Some background info, this app is running on my local machines CF Server(5b3), the SQL Server is on my local machine (v7). The same thing happens though on a CF 4.5 production machine also though... jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL update not executing?
This has nothing to do with your current question, but as to your earlier question, our DBA says it can't be done on the application level (in a web based environment, due to its stateless nature) and is dubious as a Stored Procedure. I'll bug him more about it tomorrow and see if he can't come up with a 'different' solution. Todd Ashworth - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 9:48 PM Subject: SQL update not executing? OK, no response on the question earlier, but maybe someone has seen this or can help me figure out where to look... I have a page which every once in a while will execute fully, but there is an update statement that does not update the database even though I see the query in my debug. Here is a snip from the debug: (Records=0, Time=100ms) SQL = UPDATE banners WITH (ROWLOCK) SET views = views + 1, next_rotation = next_rotation + 16 WHERE adid = 2 The debug says it happened , however when I go look at the db right after this statement and the next_rotation field hasn't budged! This does not happen every time, however it always does happen eventually. It only happens however, when I am stressing the application (which is a banner app...) with a simple 8 frame meta refresh page i did up. Some background info, this app is running on my local machines CF Server(5b3), the SQL Server is on my local machine (v7). The same thing happens though on a CF 4.5 production machine also though... jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL update not executing?
Well I seem to have beaten the problem, I spent a couple of hours taking a lot of the logic into sql server, dynamic SP's and all...whew. I still dont know why the problem happened in the first place though Thanks /me wishes I had a dba... ;-) jon - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 11:03 PM Subject: Re: SQL update not executing? This has nothing to do with your current question, but as to your earlier question, our DBA says it can't be done on the application level (in a web based environment, due to its stateless nature) and is dubious as a Stored Procedure. I'll bug him more about it tomorrow and see if he can't come up with a 'different' solution. Todd Ashworth - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 9:48 PM Subject: SQL update not executing? OK, no response on the question earlier, but maybe someone has seen this or can help me figure out where to look... I have a page which every once in a while will execute fully, but there is an update statement that does not update the database even though I see the query in my debug. Here is a snip from the debug: (Records=0, Time=100ms) SQL = UPDATE banners WITH (ROWLOCK) SET views = views + 1, next_rotation = next_rotation + 16 WHERE adid = 2 The debug says it happened , however when I go look at the db right after this statement and the next_rotation field hasn't budged! This does not happen every time, however it always does happen eventually. It only happens however, when I am stressing the application (which is a banner app...) with a simple 8 frame meta refresh page i did up. Some background info, this app is running on my local machines CF Server(5b3), the SQL Server is on my local machine (v7). The same thing happens though on a CF 4.5 production machine also though... jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists