resorting search results

[elvis_impersonating_penguin]

ok here is what i am trying to do. its not that important, its just something that would be nice to have on the page. I am trying to put something on the bottom of the search results page that will let me resort the search result by a different field.. not exactly sure how to do this.. This is what i tried already but it didn't work..

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

<INPUT TYPE="hidden" NAME="-db" VALUE="caddrawingdb.fp3">

<INPUT TYPE="hidden" NAME="-lay" VALUE="Drawing Entry Form">

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

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

<P align="left"><B><FONT SIZE="-1">Sort Results By:   <SELECT NAME="-sortfield">

<OPTION SELECTED>Model Number

<OPTION value="ActivityIDNumber">Activity ID Number

<OPTION value="Drawing Number">Drawing Number

<OPTION value="revdate">Last Change

<OPTION value="drawtype2">Metric or English

<OPTION value="drawingtype">Drawing Type

<OPTION value="prodopts">Product Options

<OPTION>unsorted

</SELECT>

   

<SELECT NAME="-sortorder">

<OPTION SELECTED>ascending

<OPTION>descending

</SELECT>     <INPUT TYPE="submit" NAME="-find" VALUE="Sort">

</FONT></B></P>

</form>

[dspires]

<OPTION VALUE="ascend" SELECTED>ascending

<OPTION VALUE="descend">descending

[elvis_impersonating_penguin]

still having problem... the problem is that none of the results are showing up.. they all just disapear instead of resorting?

[dspires]

When sorting on Model Number, I'll bet.

Try this:

<SELECT NAME="-sortfield">

<OPTION>unsorted

<OPTION value="Model Number" SELECTED>Model Number

<OPTION value="ActivityIDNumber">Activity ID Number

<OPTION value="Drawing Number">Drawing Number

<OPTION value="revdate">Last Change

<OPTION value="drawtype2">Metric or English

<OPTION value="drawingtype">Drawing Type

<OPTION value="prodopts">Product Options

</SELECT>

[elvis_impersonating_penguin]

well thanks for noticing that. but it still doesnt fix my problem.. it comes up with no records no matter what i sort by..

maybe i am just way off on how to do it.