How to Clear a Page with Form Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using FP 2003 and a server with FP Extensions. I have created a .asp
form which creates data in a page which only I can view (in the web site but
not linked to my web pages). I can populate data into that page. How can I
get rid of the data once I have retrieved it? Thanks .
 
Kevin, perhaps I wasn't clear in my question. I enter data and get a
confirmation page. The data is stored in some internal .asp database results
region. My question is how to clear that database results region once I have
the data.
George
 
The form writes the data to a database. The results region contains the
code for retrieving the data through a SQL Query.

The data is there until you navigate to another page, or do another search,
or close the browser, or whatever. The data will still be in the database.
If you don't want the data, delete it from the database.

But, I don't know if this answer your question either; we obviously aren't
understanding your question correctly.....
 
Hi George,

There is no internal .asp database results region. The data is only written
as text into the HTML document.

Data does not "come from" a database. It is copied from the database into an
in-memory "cursor," and the contents of the cursor are copied as text into
the HTML document sent to the client. When you run a SELECT statement, you
are merely getting a copy of the data in the database. To update the data,
you must send a command to the database telling it to change the record,
including a unique identifier to identify which record to change, as well as
the changed row data. To delete it, you also send a similar command to the
database.

An ASP page is a script on the web server. It contains programming code that
fetches a copy of the data from the database, and then it writes it as
(HTML) text to the Response stream, creating the HTML document that is seen
in the browser. In fact, even that is a copy. When people browse web pages,
they are not looking at the actual files, but copies of them. Once the
Response is sent to the browser, the ASP page process terminates, and its
memory is reclaimed by the operating system.

One way to think of it is to think about, for example, a Microsoft Word
document. When you open it, and begin to type, you are not writing to the
file, but to an in-memory copy of the file. That is why, if you don't save
it, when it closes, all of your work disappears. Of course, that may not be
the best example, because Word maintains a second file which it updates
periodically ("Auto-Save"), so that if you for some reason can't save it,
Word can recover the second file. Maybe Notepad would be a better example!

Fascinating, eh? That' why I do this stuff (programming) all the time. The
only thing that surprises me is that I get paid (fairly well) to do what I
do for fun!

--
HTH,

Kevin Spencer
Microsoft MVP
Software Composer
http://unclechutney.blogspot.com

A watched clock never boils.
 
Back
Top