|
The
other time you would use SQL
statements is to Update or
Delete records.
This can either be:
- Very easy (FrontPage creates the pages
for you or
- Fiendishly difficult (in .asp or .net)
If you go for the Fiendishly Difficult method
(also known as "server side coding") this is what you are
trying to achieve:
- One page that shows a unique record within an
editable text box within a form element
- The form posts to another page (update, delete)
that only has a custom SQL statement within the database results
wizard AND THEN a http:// refresh to a confirmation page (or back to
main)
Sound difficult? It can be, but once you get
the hang of it you can produce these statements with only a bit of
tinkering. The longer the statement (or # of text boxes to update)
increases the amount of errors, so updating one or 2 elements within a
form at a time is very acceptable and easier than updating the entire
form.
We suggest looking at the examples
from Spooky at Outfront.net,
they can point you in the right direction and are very clear and easy to
use.
|
