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.
