Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save trycf/9f291305a67b2a57cc8079f562cc4c47 to your computer and use it in GitHub Desktop.
Save trycf/9f291305a67b2a57cc8079f562cc4c47 to your computer and use it in GitHub Desktop.
TryCF Gist
<cfloop list="#mqry.columnList#" index="col">
<cfset ColRow ="#mqry.columnList#," >
</cfloop>
<cfset x = replace(ColRow,"CONDITION1","CONDITION") & chr(13) & chr(10)>
<cfloop query="mqry">
<cfloop list="#mqry.columnList#" index="colN">
<cfset f = Replace("#mqry[colN][currentRow]#" ,"""","","All")>
<cfset f = REReplaceNoCase("#mqry[colN][currentRow]#" , "<[^>]*(?:>|$)", "", "ALL")>
<cfset x = x & """#_FValue#"",">
</cfloop>
<cfset x = x & chr(13) & chr(10)>
</cfloop>
the first value i think i can do as:
mquery.columnlist - no need to loop over
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment