Forms calculations

[Jerry]

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

 

[Thomas A. Rowe]

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)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[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)

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




.
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

 

[Thomas A. Rowe]

Which version of FP are using?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Jerry]

-----Original Message-----
Which version of FP are using?

-- I am using frontpage2002 windows millenium
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

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




.

 

[Thomas A. Rowe]

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)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[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)

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




.

 

[Thomas A. Rowe]

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)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================