On Thu, 7 Mar 2002 16:37:40 -0500, Mark Leder wrote: I have my question solved.Thanks. -- Mark Leder, [EMAIL PROTECTED] on 03/07/2002
>I'm not sure if this is a problem with coding or an ISP problem. >My >client has been having periodic problems updating a form. We're >using an Access 2000 db backend on IIS (Win XP Platform). > >It looks like a timeout problem at first glance but I'm not so >sure. >The client states that the problem can occur when changing from >one >db record to another in a list to edit (using a form) > >"it came to essentially a total stop with the screen saying that >it >found the website and was waiting for a response. No error >message, >just that the website for whatever particular reason(s) was not >responding. Yet, I could sign off and get onto the main website >with >no problem." > >The client states further "it is not that I can't get into the >[ISP] >as I am already there, just going from one internal location [in >the >admin area] to another is the problem." > >For a point of reference, here is the Application.cfm variables: > ><cfapplication name="Admin Area" >clientmanagement="Yes" >sessionmanagement="Yes" >setclientcookies="Yes" >sessiontimeout="#CreateTimeSpan(0,0,45,0)#" >applicationtimeout="#CreateTimeSpan(2,0,0,0)#" >clientstorage="Registry"> > >I extended the timeout session to 45 minutes because this client >could be editing a record for 30 minutes or more - reading paper >references and typing them in. > >Now, here's what I use to write the update statement to the >Access >db: > ><cflock timeout="150" throwontimeout="No" type="EXCLUSIVE"> ><CFQUERY code . . .> ><updating code> ></cfquery> ></cflock> ><cflocation . . .> > >Again, timeout is set to 150 seconds just to see if there's >another >issue. > >So, to recap, is this a coding issue, or an ISP issue? If ISP, >where >would I begin or what would I want to focus in on. > >Thanks for taking time to read and respond to this long-winded >question. Your comments and insights are appreciated ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
