Clearing your DataAssist search results
I have struggled with this too. Most of the advice didnt quite work the way it was intended and that results page tenaciously held onto the search results. I found a non invasive solution using two conditional statements. I have tested it and it seams to do the trick. I thought I'd post it here as it may be of use to others.
When data assist conducts a search, it stores that fact in a session variable. That session variable will have a custom name. This is easily located by looking for where it is set in the code. So first, you put a conditional statement in that sees when the session variable for that search result is set. If so, add a link with your own custom url string trigger attached.
<cfif (isDefined("Session.WADbSearch1_officials_Results") AND Session.WADbSearch1_officials_Results NEQ "")> / <a href="officials_Results.cfm?clearsearch=true">Clear Search and Return to Results</a></cfif>
I added this code right beside the New Search link in the header as that is where I wanted it to appear if a search had been initiated. Then, at the top of the code, before the cfscript code that deals with the session variable, I added this bit of conditional logic:
<cfif (isDefined("URL.clearsearch") AND URL.clearsearch EQ "true")>
<cflock timeout=20 scope="Session" type="Exclusive">
<cfset StructDelete(Session, "WADbSearch1_officials_Results")>
Which in a nutshell detects if your custom url string is present and if so clears out the session variable set via the search. You get a clean set of results returned in the SQL statement and because the session is no longer present, the link to clear the results does not appear.
Hope this helps. I know its a hack solution but it works and could be easily adapted for ASP or PHP.