Professional Web Applications Themes

inserting # in a string - Coldfusion - Getting Started

I'm trying to insert a string that contains a # into an access database. But I get an error: Your expression might be missing an ending "#" (it might look like #expr ). I've tried using \ as an escape char but that doesn't work. Is there any way around this. What does cold fusion use as an escape char. Thanks...

  1. #1

    Default inserting # in a string

    I'm trying to insert a string that contains a # into an access database. But I
    get an error: Your expression might be missing an ending "#" (it might look
    like #expr ).

    I've tried using \ as an escape char but that doesn't work. Is there any way
    around this. What does cold fusion use as an escape char.

    Thanks

    qs01 Guest

  2. #2

    Default Re: inserting # in a string

    To escape the # symbol just use two ##

    Good lcuk!
    Stressed_Simon Guest

  3. #3

    Default Re: inserting # in a string

    To escape the # symbol just use two ##

    Good lcuk!
    Stressed_Simon Guest

  4. #4

    Default Re: inserting # in a string

    works like a charm. Thanks
    qs01 Guest

Similar Threads

  1. Inserting a variable to a text string
    By ScottP in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: March 4th, 10:16 PM
  2. Replies: 1
    Last Post: February 27th, 12:04 AM
  3. Replies: 2
    Last Post: August 16th, 10:26 AM
  4. Replies: 4
    Last Post: August 14th, 06:04 AM
  5. Parsing string and inserting characters into it.
    By Aaron Bertrand - MVP in forum ASP
    Replies: 2
    Last Post: July 10th, 10:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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