Spooky's Databases > Sending Form Information to a Database
One of the new
features of FP 2000/2, is the ability to save Form output
to an Access Database.
This opens up new possibilities in the way you can save
and display information on your web site.
How
to save a Form to a Database
- Right click on
the form
- Select 'Form
Properties'
- Select 'Send to
Database'
- Click 'Options'
- 'Create
Database'
An Access 2000 format
database is created in the /fpdb/ directory and a
database connection is made.
- Check the
'Saved fields' and 'Additional information' tabs
to add and remove any information you don't wish
to save
- Finished, click
OK
A reminder is given to
save the file with the .asp extension.
Tips
Here are some useful things to do when creating a
form:
- Always plan your
database
Plan what information
you want to save from your form, if you don't have a
copy of Access, you will have to recreate a new
database to add additional columns
To add additional
columns, either add extra form boxes (which can be
removed later) or use 'Advanced' form properties to add
hidden values.
- Don't use spaces
or odd characters
The form won't let you
use this format, with good reason. If you need spaces,
use the _ (underscore)
- You can't use
normal custom confirmation pages
If you wish to try to customize the confirmation
page, a tutorial is available here (word
document)
ASP pages do not
work well with server extensions. As the form
confirmation is a webbot, you are unable to use a
custom form without some custom modifications.
|
