My search page can not distinguish between Released and Pre Release in a pull down menu.(it works fine on the FM database) This is a problem for the people using only the web. Any suggestions? Here's the relevant html:

<FORM ACTION="FMPro" METHOD="POST">

<INPUT TYPE="hidden" NAME="-db" VALUE="techpubsdb.fp5">

<INPUT TYPE="hidden" NAME="-lay" VALUE="Detail">

<INPUT TYPE="hidden" NAME="-error" VALUE="errors.htm">

<INPUT TYPE="hidden" NAME="-lop" VALUE="or">

<input type="hidden" name="-Op" value="eq">

<INPUT TYPE="hidden" NAME="-max" VALUE="50">

<INPUT TYPE="hidden" NAME="-format" VALUE="browse.htm">

<select name ="Status">

<OPTION VALUE = "none"> [FMP-Option: Status, list=Status]

</select>

<INPUT TYPE=submit NAME="-Find" VALUE="Start Search">

Note: the list consists of Pre Release, Released, On Hold, Canceled

------------------

Regards,

Collinski

quote:

---

Originally posted by Collinski:

My search page can not distinguish between Released and Pre Release in a pull down menu.

---

You need to do an EXACT search. This is the kind of search in FMP that would be "=Find Whatever", so that it only looks for those exact values. I am not sure how this is setup in CDML though.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

quote:

---

Originally posted by captkurt:

You need to do an EXACT search.

---

Thanks Kurt, I know you're on the right track. I tried a couple things along that line, like using the 'eq' operator, but I must not be coding it right.

------------------

Regards,

Collinski

Make a hidden input in the form with the value "==" that's double-equals. the Format of the search will be...

==pre release

An illustration of the problem that spaces amd similar values cause when performing searches... I'd be tempted to change the value list to "beta, released, hold, cancelled" to avoid the problems and ambiguity.

a note, when i use the hidden field set to "==" it doesn't work for me. However a simple "=" works fine.

Just in case.

jeremy

quote:

---

Originally posted by yafreax:

a note, when I use the hidden field set to "==" it doesn't work for me. However a simple "=" works fine.

Just in case.

jeremy

---

Thanks Jeremy and Vaughan for your replies. I tried both:

<INPUT TYPE="hidden" NAME="Status" VALUE="==">

and

<INPUT TYPE="hidden" NAME="Status" VALUE="=">

and the search still couldn't tell the difference between Pre Release and Released. I'll see if I can get the db owner to change it to Beta. (good idea!)

------------------

Regards,

Collinski

Collins, the correct code is discussed and used in the Demonstration which I sent to you. Use the link at No 6 from the default or home page, "A -find action tag...".

Peace,

Keith M. Davie