I have what seems to me to be a problem with changes
made by an old application.cfm file.
I'm adding some pages to an existing application but
I'm currently doing all my development offsite with a
temporary database. This weekend was the first time I
took home some of the previously existing files to
look at the code. One of the files was an
application.cfm file which I stupidly put in the same
directory as my new files. I did not have my own
application.cfm file at the time but I do now, and the
old application.cfm file has been renamed.
I have a form which is supposed to post to itself so
it can show the entered data, and any error messages
about corrections needed, to the user before the
entered data gets put into the database. I was doing
all the entry, posting and submitting through one
page. This was working before the old application.cfm
got onto my system.
These are the bad things that happened afterwards:
No error messages displayed if an empty form is
submitted; the process skipped right through the error
message process, entered empty fields into the
database and displayed the success message. If data
was then entered into the fields and the form was
submitted again, nothing happened; the browser
reloaded the form and displayed the entered data
again, but did not put entries into the database.
I decided to split the process into two parts and use
sessions, so that the database could not get
automatically updated just by loading the
action/validation page. This prevented a blank field
update from occurring automatically, but the new form
is still not displaying the error messages when blank
fields are submitted.
Right now the temporary database has four fields, but
only the first field is being updated properly no
matter how many fields have been filled in. The rest
of the fields have blank space entered into them,
according to the SQL debugging statement displayed on
the browser.
Here are the things I have tried to get rid of any
session/application/client variables that may have
been set by the old application.cfm file:
Close the browser, shut down the server, turn client
and application management off at the server and in
code, delete cookies in the browser, turn cookies off
in the browser, have cookies reset when the browser is
closed, structDelete the sessions, a new
application.cfm file, StructClear(session) and
StructClear(application). All of this has been
repeated several times.
Perhaps I am wrong and the old application.cfm file is
not responsible, but it did have a lot of cfparam
lines. I have been careful not to have any variables
that match anything in the old cfparam lines. Also,
when I start the server and run a cf file for the
first time, it takes forever to run my application.cfm
file and momentarily flashes a dnserror.htm line at
the bottom of the browser, which makes me suspect that
something in the browser or server is still looking
for the old application.cfm file. And when JRUN first
starts, there is a line about the recovery of several
sessions, although I have done everything I can think
of to kill my sessions at the end of the processes.
I happen to know that someone else who is developing
offsite has run into the "database not being updated"
problem as well, which is one of the reasons I'm
suspecting the old application.cfm file is the
culprit.
Can anyone help me figure this out? Everything was
fine before the old files got added to my system, but
I will be happy to post my old or new code if that
will help.
Thanks.
==================================================
Laura Schlee
DML Associates
[EMAIL PROTECTED]
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
