Create field list as a string in Query of Query
Can you please correct this query
<cfquery name="getView" datasource="#Application.DSN_GDX#">
select * from vstr_entity_mast_y where tax_year=2011
</cfquery>
<cfset checkedImgStr = "<img src=../stir_images/checked.jpg>">
<cfset loopStr = "">
<cfset variables.listIds = "BNSR,BNSS,VIEW">
<cfloop index="Fld" list="#variables.listIds#">
<cfset loopStr = loopStr&'<img src=../stir_images/checked.jpg>'& " as [#Fld#],">
</cfloop>
<cfset P_loopStr = replace(loopStr, "<img src=../stir_images/checked.jpg>", "'<img src=../stir_images/checked.jpg>'", "all")>
<cfquery name="getPrivByUser" dbtype="query">
select entity_id, entity_name,#P_loopStr# leid
from getView
</cfquery>
I am getting this error:
Encountered "<. Incorrect Select Statement, Expecting a 'FROM', but encountered '<' instead, A select statement should have a 'FROM' construct.
