Testing a variable for inequality

[xSeanx]

What i'm doing is: if a searched term is not found in the database, it will
redirect the user back to the search page.
However, here is my problem, each time i compare the form input value against
the retrieved database value, nothing happens and it just continues on through
the rest of the code. What have i done wrong? it seems strange to me that a
blank field could still be equal to a field with a value.

The code:
<CFQUERY NAME="get_data" DATASOURCE="datasource">
SELECT * FROM CustomerDetails WHERE #Form.searchType# = '#Form.searchTerm#'
</CFQUERY>

<cfoutput query="get_data">
<cfif Form.searchTerm IS NOT CustomerID>
<cflocation url="url.com">
<cfelseif Form.searchTerm IS NOT CompanyName>
<cflocation url="url.com">
</cfif>
</cfoutput>
...

I've also tried using
<cfif CustomerID IS "">
But that did the exact same thing...

[zoeski80]

You could just check how many records were returned from the query and make
your decision to redirect from there.
See attached code.
HTH
Zoe

<CFQUERY NAME="get_data" DATASOURCE="datasource">
SELECT *
FROM CustomerDetails
WHERE #Form.searchType# = '#Form.searchTerm#'
</CFQUERY>

<CFIF get_data.RecordCount EQ 0>
<cflocation url="url.com">
<CFELSE>
otherwise match was found ...
</CFIF>