Validation when submitting to database

G

Guest

Hallo

I hope some one can help me i am a beginner with FrontPage 2003. I have a
form that will submit data to a database but before it does that i want it to
validate a text field first with data from the same database but a diffrent
table, basically if the text box matches with a record in the database the
submit the data to a different table in the database if it does not match
then give a error saying that it does not match.

If some one can help me with the code that i need for this that would be a
great help

Regards Markus
 
T

Thomas A. Rowe

This is not something that you can do using the FP database components. You would have to write a
custom script that would query table1, then if the record exist, then write form data to table 2,
etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top