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
--
Mark Leder, [EMAIL PROTECTED] on 03/07/2002
______________________________________________________________________
Get Your Own 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=coldfusionb
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
