Search code examples
sqldatabasecoldfusioncoldfusion-9cfml

how do i evaluate a cfif with a select statement in a string

sel_prod_dt = "select distinct change_app_code, change_number "
          & " \<cfif NDA_check eq "
          &'"Y"' 
          &"> FROM db.tb tb"
          &"\<cfelse\>FROM db.tb2 PC\<\/cfif\>"

i get the following error

Syntax error, expected something like a name or a Unicode delimited identifier between the word 'change_number' and the end of the request.

could anyone please help me in this regard..

Solution

  • Why over complicate things?

    <cfif NDA_check eq "Y">
    sel_prod_dt = "select distinct change_app_code, change_number FROM db.tb tb"
<cfelse>
    sel_prod_dt = "select distinct change_app_code, change_number FROM db.tb2 PC"
</cfif>