This bit of code allows me to find records that have a certain password. It works fine. The user types in a name and password and it finds the records only entitled to that password.

<INPUT TYPE="hidden" NAME="-op" VALUE=eq>

<INPUT TYPE=hidden NAME=SchoolCode VALUE="[FMP-Clientpassword]"></P>

SchoolCode in the db and clientpassword in the web security db are the same. What code do I need to add CDML to find all records in the DB with master as a password, master is not in the schoolcode field of the db, but in the web security db?

Thanks

Bill Joe, you may find disappointment using the tags -op and -eq. If you find that the search results are too broad (since your code may find words which are contained in the field and not exactly equal to the field) you may want to consider using the exact search feature. I have posted a link to that information in at least two places on these Internet forums in the past week. Research is good for the soul.

As to the master password in web security that won't do you much good. You need to either construct a field in your db which will contain the unique search criteria you desire, or you may consider if a -findall, -max will meet you needs. You should refer to your cdml reference.fp5.

Oh yeah, in your code (2nd line) you do not have quotes around hidden and SchoolCode. It is recommended that you use quotes around all input types, names and values. Seems to make things work better.

[ January 19, 2002: Message edited by: Keith M. Davie ]

How do you exact = in CDML?

Claris Home Page 3 keep removing the quotes you told me to add. Can I turn something off in CHP?

Thanks

I tried

<INPUT TYPE="hidden" NAME="-op" VALUE=eq>

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

<INPUT TYPE=hidden NAME=SchoolCode VALUE="[FMP-Clientpassword]"></P>

and

<INPUT TYPE="hidden" NAME="-op" VALUE=eq>

<INPUT TYPE=hidden NAME=SchoolCode VALUE==="[FMP-Clientpassword]"></P>

I could not get anyone to work?

Thanks, finally got it to work. Use the bw and not the eq.

What about putting a clear, hidden, image on the screen somewhere and add a -findall link to the image? Can I go to a different screen also with -findall.

When you use the exact search "==", you do not need to use (and you would be well advised to not use) the -op and -eq or -bw tags.

<input type="hidden" name="schoolcode" value="==">

<input type="hidden" name="schoolcode" value="[fmp-clientpassword]">

should work. Though I've never used clientpassword myself as I create my own password parameters. I realize you are using CHP, and that probably generates a lot of the capital letters. html is not case sensitive. All lower case saves strokes.