sorting search results

[texaschick]

Hi.

I am having a bit of a problem. I am hoping someone can help. I can find everything great but if i go to sort the results I get all the records in the database - not the ones I found. I have tried tokens and cookies but they are just not working. I am using FM 4 so i can only pass one token.

I was trying to pass the EmployeeName field. Any help in the right direction would be greatly appreciated.

[dspires]

Post your form code and I'm sure you'll get some help...

[texaschick]

Ok you asked for it, you got it

this is what I am using to find my records:

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

<INPUT TYPE="hidden" NAME="-db" VALUE="InMailbox.Fp3">

<INPUT TYPE="hidden" NAME="-format" VALUE="mnc/elist.htm">

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

<P>View email for<BR>

<select name="EmployeeName">

[FMP-option: EmployeeName, list=EmployeeName]

</select>

<INPUT TYPE="hidden" NAME="-LOP" VALUE="AND">

<P>Find<BR>

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

<select name="Status">

<option selected>--Choose One---

[FMP-option: Status, list=Status]

</select>

<input type="hidden" name="-Token" value="[FMP-field: EmployeeName]">

<P>

<INPUT TYPE="submit" NAME="-find" VALUE="View">

<input type="reset" value="Clear Form" name="reset">

<P> 

</FORM>

And this is what I currently have as the sort script (I have tried other ways and nothing was working, i have used -sort)

<a href="FMPro?-DB=InMailbox.fp3&-Format=mnc/elist.htm&-Script=Sort+by+Employee+Name&-Token=[FMP-CurrentToken][FMP-CurrentFind] [FMP-FindOpItem][FMP-FindFieldNameItem][FMP-FindFieldValueItem] [/FMP-CurrentFind]&-find" CLASS="Title">Employee</a>

I am sure its staring right at me - but help!

[Garry Claridge]

You can use the -sortfield tag

<INPUT TYPE="hidden" NAME="-sortfield" VALUE=" EmployeeName">

Or, is the sort on a concatenated field?

All the best.

Garry

[ June 07, 2001: Message edited by: garrycl ]