How to sort search query results and keep the results same

[olchiik]

Hello,

I need to be able to sort results by clicking on column header. I know how to do it, but the problem is it sorts all the results. I have a "search by" form. So the results I get come from that search form, depending what user is looking for. Then in the results I need to include sort by clicking on column header, but each time I click on header...it displays all the results (including those user aren't interested). So it runs query again, but since it doesn't run from the form, whatever user entered in the form, is not defined anymore. Does anybody knows way around it?

Thank you!

 

[cfSearching]

So it runs query again, but since it doesn't run from the form, whatever user entered in the form, is not defined anymore. Does anybody knows way around it?

Modify the code to pass along the search criteria whenever the header is clicked.

One option is to include the "search by" value in the column header url:

<a href="thisPage.cfm?sortBy=something&searchBy=#searchByValue#">Sort By something</a>

Another option is to use a form and store the values in hidden fields. If you use method="get" the hidden field values will be passed as url parameters.

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

http://cfsearching.blogspot.com/

 

[olchiik]

CfSearching thank you for your help. I will try to do it

 

[olchiik]

I have used form with hidden fields and I put method "get" and it didn't do anything. It still shows all results after I click on column name :-(

 

[cfSearching]

Without seeing any code, is your column name "link" actually submitting the form? If it is not, obviously none of the form field values will be passed.



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

http://cfsearching.blogspot.com/

 

[olchiik]

Oh..no it's not. How do I make it to sumit the form?

 

[cfSearching]

Either use a regular form button, or use javascript and call

document.yourForm.submit(); ... or
document.getElementById('yourForm').submit();

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

http://cfsearching.blogspot.com/

 

[olchiik]

Hi cfSearching.

I am kind of lost here. I know how to submit form using link, but I don't know how to submit and sort using same link.
There is more than one column I need to be able to sort by. I was trying it, but it still displays all records and doesn't sort:-(

 

[olchiik]

I got to the point when it displays only searched records, but sort gives me JavaScript error.
<a href="javascript:document.getElementById('passinfo').submit();&sort=feedbackregard">

I guess I cannot do it like this... but how do I add sort?

 

[olchiik]

cfSearching..I got it...
thank you for your help

 

[cfSearching]

You are welcome. I am glad you figured it out.

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

http://cfsearching.blogspot.com/