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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
