Form with FP2K & database questions

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

Guest

I created a simple form for people to fill out with their warranty
information and I have a few questions to see if I can cusotmize it
some.

One of the fields is asking for the date of purchase. Is there anyway
to set the field to convert the date to / / or - - ?

I want to import this information into an access database so i am not
sure what the best way to have the date information type in.

Secondly I have the reults saved as a comma seperated text file so I
can import the data. Is that the best way or can I have it go directly
into a database? If I can do I setup the database outside of FP2K and then
copy it to the web?

Looking for help on the best way to solve these issues.
Thanks
 
The best way to place a date field is to use three drop downs, one
each for month, day and year. Use JavaScript to validate the date
(eliminate February 30, etc), when the form is submitted assemble the
date for the database from those 3 fields using server side script.

IMO, the biggest problem with dates in a single text box is:
is 11/12/2006 the 11 December or 12 November? Separate fields takes
out the ambiguity.
 
Alternatively use JS date picker where you can control the date format
See http://www.javascriptkit.com/script/script2/tengcalendar.shtml

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| The best way to place a date field is to use three drop downs, one
| each for month, day and year. Use JavaScript to validate the date
| (eliminate February 30, etc), when the form is submitted assemble the
| date for the database from those 3 fields using server side script.
|
| IMO, the biggest problem with dates in a single text box is:
| is 11/12/2006 the 11 December or 12 November? Separate fields takes
| out the ambiguity.
| --
| Ron Symonds - Microsoft MVP (FrontPage)
| Reply only to group - emails will be deleted unread.
| FrontPage Support: http://www.frontpagemvps.com/
|
| | >I created a simple form for people to fill out with their warranty
| > information and I have a few questions to see if I can cusotmize it
| > some.
| >
| > One of the fields is asking for the date of purchase. Is there
| > anyway
| > to set the field to convert the date to / / or - - ?
| >
| > I want to import this information into an access database so i am
| > not
| > sure what the best way to have the date information type in.
| >
| > Secondly I have the reults saved as a comma seperated text file so I
| > can import the data. Is that the best way or can I have it go
| > directly
| > into a database? If I can do I setup the database outside of FP2K
| > and then
| > copy it to the web?
| >
| > Looking for help on the best way to solve these issues.
| > Thanks
| >
|
|
 
Back
Top