Hash Marks in Field Names

[aliceinthemirror]

Forgive me but I have forgotten how to do this.
I'm trying to pass the query field name: "Pat #" , which can't be changed.
<cfset pat_no = '#Pat ##'>
Problem is the hash mark in the field name.
I've tried:
<cfset pat_no = '#Pat #'#''>
but it errors out.

[Newsgroup_User · Accepted solution]

aliceinthemirror wrote:
> I've tried:
> <cfset pat_no = '#Pat #'#''>
> but it errors out.
>

You escape ColdFusion control characters by doubling them. So your line
should probably be <cfset pat_no = '#Pat ###'>

HTH
Ian

[aliceinthemirror]

Thanks for the help.
It worked fine.
Hope I can help you out one day.

[CF_output]

<cfset pat_no = 'Pat ##'> or try <cfset pat_no = '#Pat ###'> if its an actual column name - I havnt tested that one though.