Parenthesis in column name

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Parenthesis in column name

    I have a parenthesis in a column name, e.g. Discount(%). Unfortunately, I'm not
    in a position to rename the column. When I try to display the value of that
    particular column, ColdFusion treats it as a function and fails to process.

    How can I fix this behavior so that ColdFusion does not consider parenthesis
    as parameters list for a function name?

    Pythonic Guest

  2. Similar Questions and Discussions

    1. #39550 [NEW]: unlink() does not work if filename contains parenthesis.
      From: andy at advancethermal dot com Operating system: Windows XP Pro & 2003 Server PHP version: 5.2.0 PHP Bug Type: ...
    2. Font size is off (why in parenthesis?)
      Okay, why does the size of one font in InDesign look like this? 11 pt(7.08) What's the deal here?
    3. ruby 1.8 space before argument parenthesis
      Hi, I have just moved over to using 1.8 and on a previously working script I now get @field = getField (line) warning: don't put space before...
    4. Regular expressions and parenthesis in match text
      Hi folks, I'm going bonkers with what should be a simple problem. I'm trying to change this text (don't worry about <ul> & </ul>, I've got that...
    5. nested parenthesis in regex and launching a new process
      Two quick questions for the gurus: 1. How are nested parenthesis in a match m// backreferenced? I have a folder full of files: file_3.0...
  3. #2

    Default Re: Parenthesis in column name

    Okay got. I surrounded it with [ ] and its working now.
    Pythonic Guest

  4. #3

    Default Re: Parenthesis in column name

    But is there a solution to print the value of such a variable without having the rename the column name in the query?
    Pythonic Guest

  5. #4

    Default Re: Parenthesis in column name

    But is there a solution to print the value of such a variable without having torename the column name in the query?
    Pythonic Guest

  6. #5

    Default Re: Parenthesis in column name

    query[columnName][row]

    Where columnName is a string containing the column name.

    --

    Adam
    Adam Cameron Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139