Suppose I have a
and x = <cfqueryparam value=#x# ...>
and y = <cfqueryparam value=#y# ...>
and z = <cfqueryparam value=#z# ...>
can I include this in a query
<cfquery name='testme" datasource="MM2005">
select * from myschema.mytable
and .... = ....
Is this possible...
(seems an app I am working on has several nested loops which are running basically 4 similar queries for a total 13 times each).
In the itermim
I would like to seperate the where clause into 2 where clauses and add the same where clause portion to each query appending to whatever is different in the where clauses.
sorry if it doesn't make sense, I just need to see how I can add <cfqueryparam's to a query when they are part of a variable (sqlWHERE).