This is a weird one folks! I have a site that people login to
access a very large profile application. They basically have to
fill out 5 large forms before being able to utilize the services of
this website. These 5 forms have a corresponding database table
(sql server). The problem I'm having is that occasionally, when
someone fills out the form (which can take up to an hour, possibly
a little more) and submits it, the form just goes blank and the
data does not get updated in the database (using a standard sql
update query)! As you can imagine, this is very frustrating for
someone who just spent an hour filling out a form and not having it
saved!
Here is some additional detail...
It has happened with all the forms
(although I think it happens the most with the two bigger ones that
have several textarea boxes).
there are no errors of any kind
Not a session thing because the
timeout is set to like 5 hours and I've thoroughly tested to make
sure the timeout goes to the login page
happens with both cf 6.1 and cf7 and
a sql server 2000 database
cannot tell if this is a browser
problem (for instance, does IE have problems submitting massive
forms?), a CF thing or a sql / database thing. If anyone has any
thoughts, I certainly welcome them!