I do this to get some form of transaction support in MySQL. Works fine, but not a good idea for a site where there might regularly be more than a few concurrent users. If you're using access though, this is unlikely to be the case.
Mark At 01:50 PM 10/9/2001, you wrote: >If it is a timing issue you might try throwing a pair of named locks around >them, that would help to single thread the process but will result in more >over head. Just a thought. > ><cflock timeout="10" throwontimeout="No" name="bla" type="EXCLUSIVE"> >do query tags here ></cflock> > >Bryan LaPlante > >----- Original Message ----- >From: "kaigler" <[EMAIL PROTECTED]> >To: "CF-Server" <[EMAIL PROTECTED]> >Sent: Monday, October 08, 2001 11:43 AM >Subject: error handling question > > >I occasionally get the following error.... > >ODBC Error Code = S1000 (General error) >[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable >query. >SQL = "UPDATE dbcounter SET CounterVal = 91765 where >CounterName='pagecounter'" > >Basically, when I had the problem the other week regarding my cold fusion >crashing all the time, I placed this code in there to keep track of all >pages being hit. All this code is doing is incrementing a self made >counter that I have in my database. > >My guess is that too many people are hitting this page at the same time and >the file is locked and so it throws out an error. Is this possible? > >Instead of throwing an error can I have the page continue on and ignore any >error that may have occurred here? > >thanks in advance, >kaigler > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
