Compass Travel example search not working

[KevCB]

Hi

I seem to be having a problem copying the example Compass Travel application
in the pdf files.

When I've copied the code to create the first part of the search with the
tripLocation as the WHERE clause in the query.
When running the search with selecting the begins with from the select box and
using C, it brings back absolutely nothing.
Yet if I run the search selecting is and type in China, it brings back the one
record like it says in the PDF file.

It seems as if the query isn't running the wildcard for the begins with
search, when running through the examples has anyone encountered this problem,
or know why this is happening?

Thanks

Here's my function in the CFC:


<cffunction name="getTripsFromForm" output="false" access="public"
returntype="query">
<!--- Create WHERE clause from data entered via search form --->
<cfset WhereClause = " 0=0 ">
<!--- Build subclause for trip location --->
<cfif Form.tripLocationOperator GT "">
<cfif Form.tripLocationOperator EQ "EQUALS">
<cfset WhereClause = WhereClause & " and tripLocation = '" &
form.tripLocationValue & "'">
<cfelse>
<cfset WhereClause = WhereClause & " and tripLocation = '" &
form.tripLocationValue & "%'">
</cfif>
</cfif>
<cfquery name="TripResult" datasource="CompassTravel">
SELECT tripID, tripName, tripLocation, departureDate, returnDate, price
FROM trips
WHERE #PreserveSingleQuotes(WhereClause)#
</cfquery>
<cfreturn TripResult>
</cffunction>

[KevCB]

Doesn't matter now, I missed out the 'Like' in the WHERE clause.

It should have been:

<cfset WhereClause = WhereClause & " and tripLocation Like '" & form.tripLocationValue & "%'">