Forms calculations

Can anyone tell me how make viewing my form database
private. I am using fp2002 and windows millenium. my host
provides fp extensions and asp. Also, if someone can show
me an example of how to upate a database so that it adds
subtracts multiplies or divdes and then updates the data
base with the answers. Thank you jerry

What is a form database?

To do calculation, you either need to use JavaScript (in the browser) or ASP (VBScript) on the
server to calculate and then write to a database, this will require you to learn to code in VBScript
and not rely on the FP database components.

Also, even with your host supporting FP extensions and ASP, the host must be running a Windows IIS
server to allow you to use Access.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jerry" <anonymous@discussions.microsoft.com> wrote in message
news:2c6be01c469f2$3da0b180$a601280a@phx.gbl...
> Can anyone tell me how make viewing my form database
> private. I am using fp2002 and windows millenium. my host
> provides fp extensions and asp. Also, if someone can show
> me an example of how to upate a database so that it adds
> subtracts multiplies or divdes and then updates the data
> base with the answers. Thank you jerry

>-----Original Message-----
>What is a form database?
>
>To do calculation, you either need to use JavaScript (in
the browser) or ASP (VBScript) on the
>server to calculate and then write to a database, this
will require you to learn to code in VBScript
>and not rely on the FP database components.
>
>Also, even with your host supporting FP extensions and
ASP, the host must be running a Windows IIS
>server to allow you to use Access.
>
>--
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Jerry" <anonymous@discussions.microsoft.com> wrote in
message
>news:2c6be01c469f2$3da0b180$a601280a@phx.gbl...
>> Can anyone tell me how make viewing my form database
>> private. I am using fp2002 and windows millenium. my
host
>> provides fp extensions and asp. Also, if someone can
show
>> me an example of how to upate a database so that it adds
>> subtracts multiplies or divdes and then updates the data
>> base with the answers. Thank you jerry
>
>
>.
>Can you tell me, once the form is filled out the data
goes to a database. Is there a way that the database
records can be viewed privatley. I think I have seen web
sites collect contact information of future clients, but
don't want anyone to have a list of their new clients
published on the internet. thanks Jerry

Which version of FP are using?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jerry" <anonymous@discussions.microsoft.com> wrote in message
news:2d0ca01c469fc$889d45e0$a401280a@phx.gbl...
>
> >-----Original Message-----
> >What is a form database?
> >
> >To do calculation, you either need to use JavaScript (in
> the browser) or ASP (VBScript) on the
> >server to calculate and then write to a database, this
> will require you to learn to code in VBScript
> >and not rely on the FP database components.
> >
> >Also, even with your host supporting FP extensions and
> ASP, the host must be running a Windows IIS
> >server to allow you to use Access.
> >
> >--
> >==============================================
> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >WEBMASTER Resources(tm)
> >http://www.ycoln-resources.com
> >FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >==============================================
> >To assist you in getting the best answers for FrontPage
> support see:
> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> >"Jerry" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:2c6be01c469f2$3da0b180$a601280a@phx.gbl...
> >> Can anyone tell me how make viewing my form database
> >> private. I am using fp2002 and windows millenium. my
> host
> >> provides fp extensions and asp. Also, if someone can
> show
> >> me an example of how to upate a database so that it adds
> >> subtracts multiplies or divdes and then updates the data
> >> base with the answers. Thank you jerry
> >
> >
> >.
> >Can you tell me, once the form is filled out the data
> goes to a database. Is there a way that the database
> records can be viewed privatley. I think I have seen web
> sites collect contact information of future clients, but
> don't want anyone to have a list of their new clients
> published on the internet. thanks Jerry

>-----Original Message-----
>Which version of FP are using?
>
>-- I am using frontpage2002 windows millenium
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Jerry" <anonymous@discussions.microsoft.com> wrote in
message
>news:2d0ca01c469fc$889d45e0$a401280a@phx.gbl...
>>
>> >-----Original Message-----
>> >What is a form database?
>> >
>> >To do calculation, you either need to use JavaScript
(in
>> the browser) or ASP (VBScript) on the
>> >server to calculate and then write to a database, this
>> will require you to learn to code in VBScript
>> >and not rely on the FP database components.
>> >
>> >Also, even with your host supporting FP extensions and
>> ASP, the host must be running a Windows IIS
>> >server to allow you to use Access.
>> >
>> >--
>> >==============================================
>> >Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >WEBMASTER Resources(tm)
>> >http://www.ycoln-resources.com
>> >FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >==============================================
>> >To assist you in getting the best answers for FrontPage
>> support see:
>> >http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >
>> >"Jerry" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:2c6be01c469f2$3da0b180$a601280a@phx.gbl...
>> >> Can anyone tell me how make viewing my form database
>> >> private. I am using fp2002 and windows millenium. my
>> host
>> >> provides fp extensions and asp. Also, if someone can
>> show
>> >> me an example of how to upate a database so that it
adds
>> >> subtracts multiplies or divdes and then updates the
data
>> >> base with the answers. Thank you jerry
>> >
>> >
>> >.
>> >Can you tell me, once the form is filled out the data
>> goes to a database. Is there a way that the database
>> records can be viewed privatley. I think I have seen
web
>> sites collect contact information of future clients, but
>> don't want anyone to have a list of their new clients
>> published on the internet. thanks Jerry
>
>
>.
>

Ok.

1. You can create results page, that is not linked to any other page within your site, and give it a
strange name, that would not be easily to guess.

2. You can open the live site every so often and export the database to your desktop, then open in
Access to review the records.

3. You can learn how to write a ASP (VBScript) login script, that would require that you enter a
login and password to view the results.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jerry" <anonymous@discussions.microsoft.com> wrote in message
news:2d16a01c46a09$41ed30d0$a401280a@phx.gbl...
>
> >-----Original Message-----
> >Which version of FP are using?
> >
> >-- I am using frontpage2002 windows millenium
> >==============================================
> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >WEBMASTER Resources(tm)
> >http://www.ycoln-resources.com
> >FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >==============================================
> >To assist you in getting the best answers for FrontPage
> support see:
> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> >"Jerry" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:2d0ca01c469fc$889d45e0$a401280a@phx.gbl...
> >>
> >> >-----Original Message-----
> >> >What is a form database?
> >> >
> >> >To do calculation, you either need to use JavaScript
> (in
> >> the browser) or ASP (VBScript) on the
> >> >server to calculate and then write to a database, this
> >> will require you to learn to code in VBScript
> >> >and not rely on the FP database components.
> >> >
> >> >Also, even with your host supporting FP extensions and
> >> ASP, the host must be running a Windows IIS
> >> >server to allow you to use Access.
> >> >
> >> >--
> >> >==============================================
> >> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >WEBMASTER Resources(tm)
> >> >http://www.ycoln-resources.com
> >> >FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> >==============================================
> >> >To assist you in getting the best answers for FrontPage
> >> support see:
> >> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >> >
> >> >"Jerry" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >news:2c6be01c469f2$3da0b180$a601280a@phx.gbl...
> >> >> Can anyone tell me how make viewing my form database
> >> >> private. I am using fp2002 and windows millenium. my
> >> host
> >> >> provides fp extensions and asp. Also, if someone can
> >> show
> >> >> me an example of how to upate a database so that it
> adds
> >> >> subtracts multiplies or divdes and then updates the
> data
> >> >> base with the answers. Thank you jerry
> >> >
> >> >
> >> >.
> >> >Can you tell me, once the form is filled out the data
> >> goes to a database. Is there a way that the database
> >> records can be viewed privatley. I think I have seen
> web
> >> sites collect contact information of future clients, but
> >> don't want anyone to have a list of their new clients
> >> published on the internet. thanks Jerry
> >
> >
> >.
> >

I am using fp2002 and windows millenium.
>-----Original Message-----
>Which version of FP are using?
>
>--
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Jerry" <anonymous@discussions.microsoft.com> wrote in
message
>news:2d0ca01c469fc$889d45e0$a401280a@phx.gbl...
>>
>> >-----Original Message-----
>> >What is a form database?
>> >
>> >To do calculation, you either need to use JavaScript
(in
>> the browser) or ASP (VBScript) on the
>> >server to calculate and then write to a database, this
>> will require you to learn to code in VBScript
>> >and not rely on the FP database components.
>> >
>> >Also, even with your host supporting FP extensions and
>> ASP, the host must be running a Windows IIS
>> >server to allow you to use Access.
>> >
>> >--
>> >==============================================
>> >Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >WEBMASTER Resources(tm)
>> >http://www.ycoln-resources.com
>> >FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >==============================================
>> >To assist you in getting the best answers for FrontPage
>> support see:
>> >http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >
>> >"Jerry" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:2c6be01c469f2$3da0b180$a601280a@phx.gbl...
>> >> Can anyone tell me how make viewing my form database
>> >> private. I am using fp2002 and windows millenium. my
>> host
>> >> provides fp extensions and asp. Also, if someone can
>> show
>> >> me an example of how to upate a database so that it
adds
>> >> subtracts multiplies or divdes and then updates the
data
>> >> base with the answers. Thank you jerry
>> >
>> >
>> >.
>> >Can you tell me, once the form is filled out the data
>> goes to a database. Is there a way that the database
>> records can be viewed privatley. I think I have seen
web
>> sites collect contact information of future clients, but
>> don't want anyone to have a list of their new clients
>> published on the internet. thanks Jerry
>
>
>.
>

If you want the calculation done in the user browser, you will need to do a search in the IE address
bar for:

? JavaScript Form Calculation Scripts

If you want to do the calculation after the form has been submitted, you will have to learn ASP
(VBScript) to do the calculation prior to writing to the database.

To view the data, you can create a results page that is not link to any other page in your web or
you could just export the database from the live site to your desktop to see the records.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jerry" <anonymous@discussions.microsoft.com> wrote in message
news:2da1301c46a8c$9c9124a0$a401280a@phx.gbl...
> I am using fp2002 and windows millenium.
> >-----Original Message-----
> >Which version of FP are using?
> >
> >--
> >==============================================
> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >WEBMASTER Resources(tm)
> >http://www.ycoln-resources.com
> >FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >==============================================
> >To assist you in getting the best answers for FrontPage
> support see:
> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> >"Jerry" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:2d0ca01c469fc$889d45e0$a401280a@phx.gbl...
> >>
> >> >-----Original Message-----
> >> >What is a form database?
> >> >
> >> >To do calculation, you either need to use JavaScript
> (in
> >> the browser) or ASP (VBScript) on the
> >> >server to calculate and then write to a database, this
> >> will require you to learn to code in VBScript
> >> >and not rely on the FP database components.
> >> >
> >> >Also, even with your host supporting FP extensions and
> >> ASP, the host must be running a Windows IIS
> >> >server to allow you to use Access.
> >> >
> >> >--
> >> >==============================================
> >> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >WEBMASTER Resources(tm)
> >> >http://www.ycoln-resources.com
> >> >FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> >==============================================
> >> >To assist you in getting the best answers for FrontPage
> >> support see:
> >> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >> >
> >> >"Jerry" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >news:2c6be01c469f2$3da0b180$a601280a@phx.gbl...
> >> >> Can anyone tell me how make viewing my form database
> >> >> private. I am using fp2002 and windows millenium. my
> >> host
> >> >> provides fp extensions and asp. Also, if someone can
> >> show
> >> >> me an example of how to upate a database so that it
> adds
> >> >> subtracts multiplies or divdes and then updates the
> data
> >> >> base with the answers. Thank you jerry
> >> >
> >> >
> >> >.
> >> >Can you tell me, once the form is filled out the data
> >> goes to a database. Is there a way that the database
> >> records can be viewed privatley. I think I have seen
> web
> >> sites collect contact information of future clients, but
> >> don't want anyone to have a list of their new clients
> >> published on the internet. thanks Jerry
> >
> >
> >.
> >