cfqueryparam and wildcard select for search

[runner ed]

Quick Question.

I am having some difficulty with this select statement for a search:

SELECT * FROM table WHERE name like ''<cfqueryparam
value="#form.txtCompanySearch#" cfsqltype="cf_sql_varchar">''%'"

This statement always fails. What changes do I need to make to the syntax? I
want to be able to have the user enter the first few characters, then append a
wildcard to the variable using the cfqueryparam. I have tried different
variations to escape the % symbol but nothing seems to work.

IE: SELECT * FROM table WHERE name like 'abc%'

Thanks for the help.

[Jochem van Dieten - TMM]

runner ed wrote:

> Quick Question.
>
> I am having some difficulty with this select statement for a search:
>
> SELECT * FROM table WHERE name like ''<cfqueryparam
> value="#form.txtCompanySearch#" cfsqltype="cf_sql_varchar">''%'"

SELECT *
FROM table
WHERE name like <cfqueryparam value="#form.txtCompanySearch#%"
cfsqltype="cf_sql_varchar">

Jochem

--
Jochem van Dieten
Team Macromedia Volunteer for ColdFusion, beer and fun.

[The ScareCrow]

like so,
SELECT * FROM table WHERE name like <cfqueryparam value="#form.txtCompanySearch#%" cfsqltype="cf_sql_varchar">

Ken

[runner ed]

That worked. Thanks.