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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
