The name of the form, 'Form1' in this example, is only
relevant on the
client and is used in JavaScript type client side processing.
On the server, data submitted from a 'post' request is always
contained
in the 'form' scope and is referenced as such, irrespective
of what the
from was named on the client.
So your code should just be: LIKE '#FORM.input#'.
Naming your controls more specifically then 'Form1' and
'input' would
make for more easily understood source code.
Also, it is a great habit to get used to using
<cfqueryparam...> in all
your <cfquery...> blocks. Learn it early and it saves
retraining
oneself later.