Can entry in html form become FM query criteria?

valyent · January 20, 2003

From a HTML form on a page within my site, I would like to "on submit", access my FM Web published database and using the "Job Number" entered, serve a read only view of the record relating to the job number entered ie:

1. User enters job number "xyz" in field of form on html page;

2. Submit button calls up the database at dns and searches for "xyz" info

3. Displays a read only layout with necessary data.

Any help would be appreciated...

Garry Claridge · January 20, 2003

This can be done with ease using Custom Web Publishing (CWP). For example:

http://mydomain/FMPro?-db=mydb.fp5&-lay=mylay&-format=results.html&job_num=xyz&-find

or

<form action="FMPro" method="post>

<input type="hidden" name="-db" value="mydb.fp5">

<input type="hidden" name="-lay" value="mylay">

<input type="hidden" name="-format" value="results.html">

Enter Job Number: <input type="text" name="job_num" value="">

<input type="submit" name="-find" value="Show Job">

</form>





The Format file (results.html) would look like this:


<html><head></head><body>

Details:<br>

[FMP-Field:job_name] [FMP-Field:anyother fields.....

</body></html>

All the best.

Garry

Sign In

Can entry in html form become FM query criteria?

Recommended Posts

valyent

Garry Claridge

Create an account or sign in to comment

Create an account

Sign in

Browse

Site Support

Forums

Blogs

Marketplace

Activity

Important Information