I am using fx.php and fmstudio. I am proficient in Filemaker, however am new to bringing it to the web.

I have created a search form using fmstudio based on two fields. I want to specify 1) a value is required for a particular field, 2) a min number of characters that are required for the field, 3) the search should show results "exactly" as input.

I appreciate any help

Thanks

Hi,

You can achieve this using JavaScript validation. Dreamweaver 8 has JavaScript validation built for text fields. The Validation can be set to nubmer of characters allowed to be entered as well as making sure a field has content. (Is not empty)

I would take a look at the http://www.fmwebschool.com/fmstudio.php Dreamweaver 8 Video Series that I created. It covers Dreamweaver and JavaScript Validation. You receive a free copy of these videos when you purchase FMStduio. Please email me at [email protected] if you did not receive a copy.

Also, we have a FMStudio forum with about 700 posts you might want to check out. It is full of great questions and answers at:

http://www.fmwebschool.com/frm/index.php

In Kindness

Stephen Knight

Hi Stephen,

Thanks a bunch. I got the dwvideos and it did help, and was really simple. However, I am still not sure how, or if it is possbile to do and "exact" criteria search.

For example right now, if a search is done online you can put in a partiall name, and you will get results from every record with that same partial name in that particular feild.

I would like for the search to be strict so that the results would be exactly as entered in the search field.

Thanks again for your help already, and thanks to allyson also. You guys are great

[email protected]

I'm glad that we could help! Yes certainly, just try using the operator and disable wildcards from the variable selector. Don't use "*" you will need to use the "==" operator.

In Kindness

Stephen Knight

http://www.fmwebschool.com/fmstudio.php

Okay, I have got one more question. I am making progress with this, I promise, and I really appreciate your help.

I have got the search working as an "exact" search using the == operator. However, I am searching two fields.

I only want to return the results where both fields match exactly. For example, now when I search, if I get an exact match on one of the fields and a partiall match on the second field, it returns a result.

How do I create a search that will only return results where both fields make an exact match?

You should just use the "==" on both fields - that should work a treat.

In Kindness

Stephen Knight