Is it possible to rebind sql paramters using the result from a cfquery?
- by Larry
When I run the following code:
<cfquery name="someQuery" result="queryResult" datasource="wetakepictures">
SELECT id
FROM events
WHERE category_id = <cfqueryparam value="1" cfsqltype="cf_sql_integer">
OR title like <cfqueryparam value="%test%" cfsqltype="cf_sql_varchar">
</cfquery>
<cfoutput>
#queryResult.sql# <br />
#ArrayToList(queryResult.sqlparameters)#
</cfoutput>
It outputs:
SELECT id FROM events WHERE category_id = ? OR title like ?
1,%test%
I need the actual string "SELECT id FROM events WHERE category_id = 1 OR title like '%test%'".
Is there a way to rebind the parameters to the sql?
