214-564-5316
Thursday, November 20, 2008

Upload Text to Database and Display in Text Box

The zip file named todb.zip contains all the files you need.

The access database named "content.mdb" should be uploaded into your fpdb folder that has read/write permissions correctly set for it (use your control panel or call your host).
You may use another database folder but you must then change the path to the database in the results.asp page and the todb.asp page from fpdb/content.mdb to your new folder.
The database table is named "comments" and has four columns: ID, xtitle, xcomments, and submitted.

The form page (form.htm) allows you to submit data to the database via the todb.asp page.  You will be automatically referred to the thankyou.asp page with a link that takes you to view the results in the results.asp page.

You will notice simple validation on the form fields and a simple bit to let folks know they've stumbled on the thankyou.asp page by mistake. You can use html in the text box and include links, etc. also.

Have fun and good luck!