dbtype=query with like

can you not say simply
<cfquery name='newquery' dbtype='query'>
select * from tblcustomers where stfname like '%joe%'
</cfquery>

If you are trying to create a query that may or may not
perform a where clause, you can embed <cfif>s in your
query

<cfquery name='newquery' >
select * from tblcustomers <cfif isdefined('var')> where sftname like
'%#var#%'</cfif>
</cfquery>



--
Tami
aka DixieGal

**************************
The brain is a wonderful organ. It starts working the moment you get up in
the morning
and does not stop until you get into the office.
--Robert Frost
**************************

"joeEarl" <webforumsuser@macromedia.com> wrote in message
news:d02kqu$he8$1@forums.macromedia.com...
| Has anyone been able to use LIKE in a select statement of a query of
queries?
| Doing this causes an error:
|
| <cfquery name = "lastQuery" datasource = "Development">
| SELECT * FROM tblCustomers
| </cfQuery>
|
| <cfquery name = "newQuery" dbtype = "query">
|
| SELECT * FROM lastQuery where STFNA
ME LIKE '%joe%'
| </cfquery>
|