dynamic sql statement with cfqueryparam

[CF_Greg]

I am trying to dynamically build a SQL statement (the ENTIRE statement) and
palce it into a variables.sqlString to be run later via

<cfquery name="foo" datasource="myDS">
#variables.sqlString#
</cfquery>

The issue I'm dealing with is I am trying to use CFQUERYPARAM as part of the
sql statement (which get put into a string). I wasn't sure if I'd be able to
put a cfqueryparam into a SQL statement to run later, and it looks like I might
be right. Has anyone been able to do this?

Here's a small clip of how how I am building the SQL:

sqlStatement = sqlStatement & ') VALUES (<cfqueryparam
cfsqltype="cf_sql_integer" value="#variables.keyID#">, <cfqueryparam
cfsqltype="cf_sql_varchar" value="#currentLocale#">, ';

etc.

[jdeline]

The first occurrence of cfqueryparam will begin with ), unless you are taking
care of that special case. And even though your example does not contain a
single quote, it would be a good idea to
#PreserveSingleQuotes(variables.sqlString)#

BTW, what error message are you getting?