Front Page forms data

[LDaveM]

Need help here. I have a client who has a form and wants to collect the data then redisplay the data in a new page on his web site. Hosting company uses Unix, ASP, mySQL.. Client does not want to pay for Data base if it is not needed. Is there any way one can use Excel or othet tools to do this?
Thanks,
Dave

 

[CoreyBryant]

Just to verify - are you sure it is ASP? If they are on a UNIX box - it might be PHP/MySQL. ASP is usually ran on a Windows platform unless the UNIX box has Chilisoft installed.

__________________________
Corey

http://www.merchantaccounts4less.com/promo/tek.asp

 

[LDaveM]

Yes, they support ASP Active Server Pages

 

[CoreyBryant]

OK.. Well mySQL is a database. Do you know if they support MS Access? if not - see if they can create a DSN to the mySQL DB & you can connect to it via FP.

__________________________
Corey

http://www.merchantaccounts4less.com/promo/tek.asp

 

[LDaveM]

Does not support Access. DSN?
Thanks
Dave

 

[CoreyBryant]

I do not know if FP ASP is supported by ChiliASP. That sounds like what they have on their UNIX server. You would be better off using PHP to create the connection.

A DSN is data source name. It is a type of connection to talk to a database.

FP will not create PHP though for you.

__________________________
Corey

http://www.merchantaccounts4less.com/promo/tek.asp

 

[kimmer7389]

You can actually have the form submit to a .csv file. If your client wants to view the data you can give him a link or link a web page to the .csv file. A .csv file is an Excel file. Its not pretty but its cheap and easy. You can save the .csv to a local drive and format it anyway you want or import it into an Access database.

If you want pretty then I would use the php/mySQL solution. A little more work but its free as well.

If you want more information about how to save data to a .csv file reply to this post and it will send me an e-mail.

 

[LDaveM]

kimmer,
Yes, I would like more info on how to do this.
Thanks,
Dave

 

[kimmer7389]

Dave,

This is how you do it.

I am assuming that your site is created and published using FrontPage. I am also assuming that your development area has FP extensions on it.

Create your form with FrontPage.

Your probably going to want to keep the form results in the _private folder so...

Right mouse click on the form and choose Form Properties. In the Form Properties, under where to store results, in the Send To File Name: enter _private/filename.csv

Test the form in your browser and submit it. This should create the .csv file in your _private folder.

If you are working in a development area publish the form to your production area.

When you want to view the results either access the .csv file through FP on your production server or through a browser using the url to the file on your production server. You can save the .csv file to your computer and do what you want with it.


Hope this works.