[thelist] CF/SQL: Utterly Baffled!

Hi Frank,


:) Here's what I've got
:) 
:) <cfquery name="theName" datasource="theTable">
:) 
:) select id, nameFirst, nameLast, etc...
:) from theTable
:) 
:) where
:) 

Here's your problem:

:) nameFirst like #form.nameFirst#
:) (...etc...)

Add single quotes around the query string (since you're specifying text;
numbers do not need the single quotes), add the % sign where you want the
wildcard.  Like this:

nameFirst like '#form.nameFirst#%'
(...etc...)

Good Luck,

Seth