Skip to main content
K
kfnavara
Participant
June 1, 2011
Question

Database table column name contains # sign

  • June 1, 2011
  • 2 replies
  • 1570 views

I need to query a database table (I cannot rename the column names) in where the column name contains a # sign (PRICE_OR_DISC#1). This causes CF to crash because of the # sign. Is there a way to query a column name that contains a # sign?

    This topic has been closed for replies.

    2 replies

    K
    kfnavaraAuthor
    Participant
    June 1, 2011

    My apologies and thanks to all. I tried "tpi.PRICE_OR_DISC##1," again, which I was positive that tried more than once and it works now. Obviously operator error on my part.

    Thanks so much for helping me to the solution!

    Owainnorth
    Owainnorth
    Inspiring
    June 1, 2011

    Double-hash escapes a hash within CF.

    K
    kfnavaraAuthor
    Participant
    June 1, 2011

    Yes, I tried that but I need to keep one hash (#) because it is part of the column name. Thanks!

    D
    Dan_Bracuk
    Inspiring
    June 1, 2011

    Your post is too vague.  What did you try and what was the result?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices