SQL Encapsulation In variable

[Guest]

I think i am missing some thing . when i am doing some thing like this its working

<cfset QueryA = "Select * from Test">
<cfquery name="ABC" datasource="ABC">
#QueryA#
</cfquery>

But how to Add where in IT . ??

<cfset QueryA = "Select * from Test where country = 'US' ">
<cfquery name="ABC" datasource="ABC">
#QueryA#
</cfquery>

i am just trying to make a Dynamic Query . any other ideas are welcomed

[Dan_Bracuk]

First, of all, you have to use the preservesinglequotes function to get querya to run as written.

My other idea is to only make part of the sql dynamic. Something like:

select somefields
from test
where country in (#ListQualify(yourvariable, "'")#)

[Guest]

Dan thanks for the reply . but i am trying to get Input from IM . through Eventgateway and arguments.CFEvent.DATA.Message is comming as a String .