How can I display the search words on the search results page

Dear WebAssist,

I am sorry for this question but I have not been able to find an answer on the forum. I am sure this is quite easy but have struggled to figure out a way to display the search terms on the results page. i.e if a customer searches for "chicken salad" on the results page I would like to display "chicken salad" to remind the customer what he just searched for.

Many thanks as always

There might be other methods, but usually what I do is use the cookie toolkit, and use it to set a session variable to the posted search variable, and set the trigger to to the search button on your form pressed.

You can then drag the session variable from the bindings panel onto your search page.

Hope that helps.
Tom

Dear AlaskaTom,

Thank you for your reply, that is really helpful. My concern with using cookies it that I am using this for a support system, were a question the customers asks is searched in the FAQ's before allow that question as well as customer comments is send. So if anyone has cookies disabled the original question will not be pasted and left blank.

I am wondering if there may be another way that is can be done that is entirely server side?

Actually, I recommended using session variables, not cookies, so no worries

yes, using session variables is a better method.

On the results page, open the bindings panel. Click the plus button and select Form data. In the form data dialog, select the search page. This will add dynamic data bindings for the search form on the results page.

Now open the server behaviors panel, and select WA Cookies Toolkit -> Set Session Value.

Set the trigger to any form post, click the lightning bolt next to value and select one of the form elements from the search form. set the name to the same name as the form element.

Repeat that step for each form element.

yoou can then add the session bindings to the results page to display the search terms.

Thank you Jason and thank you AlaskaTom.

Your help worked beautifully for getting the form information into session variables, thank you, I am so grateful

glad to hear it is working.

Just to expand on this question. I have a few search form that all point to the same results page. What I would like to do is store the search query in my mysql DB so that I can see what people are searching for to help me provide relevant content.

If I use the above method I think I would have to create a form data for all the pages were the search form exists. and then put that search word into a session variable and then insert into the mysql row.

Is there a better method. I though maybe I could take the session variable ( WADbSearch1) created by data assist search. But I was not able to.

What would be the best way to be able to store the search terms in a DB if the search terms are coming from multiple pages that have the search form.

Thank you all as always for your help

using the WADbSearch1 session would be the best way.

for this to work tough, you may need to move the insert record code on the page so that it is after the data assist search code.

Dear Jason,

Thank you for your help. I did place the DA Insert server behaviour below the search but when the form is submitted I get these errors.


Notice: Undefined variable: SResultDB in /Volumes/My Book/DataBases/Cura Romana Project DB/Cura Romana Project/Folders/Website (dreamweaver) Files/CuraRomana Large official/curaromana/FAQ/Search/index.php on line 122

Notice: Undefined variable: database_SResultDB in /Volumes/My Book/DataBases/Cura Romana Project DB/Cura Romana Project/Folders/Website (dreamweaver) Files/CuraRomana Large official/curaromana/FAQ/Search/index.php on line 134

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /Volumes/My Book/DataBases/Cura Romana Project DB/Cura Romana Project/Folders/Website (dreamweaver) Files/CuraRomana Large official/curaromana/FAQ/Search/index.php on line 135

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Volumes/My Book/DataBases/Cura Romana Project DB/Cura Romana Project/Folders/Website (dreamweaver) Files/CuraRomana Large official/curaromana/FAQ/Search/index.php on line 139

They looked to me like there was a problem with my DB connection which I have tested to make sure it is working correctly and it appears to be. I have included the results page. Any ideas?

Many thanks again