Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default ' & insert problem

    Hi,

    Whats the best way to handle clients submitting ' in form fields
    i.e. richard's
    would throw an error when using sql to insert into the database like this
    '#FORM.thisField#'

    Thanks,


    Richard

    Dicky Guest

  2. Similar Questions and Discussions

    1. a problem about cfinsert&sql.insert
      hi~ when i insert data into form,there is a stranger things happend: when i insert with one value ,it's ok,but when changing the number of the...
    2. Insert link problem
      I have switched to a new computer and can access my web pages, but cannot insert any links. (or add new pages). When I click on Insert Link, I get...
    3. INSERT MAX(ID) Syntax problem
      Trying to get the ID (autonumber) of a record that has just been inserted and insert it into a different table but I either get a syntax error or a...
    4. Problem with insert
      I have the following code in an ASP page that is processing a form to create a new user. I keep getting the following error Microsoft JET...
    5. multiple insert problem !
      hi ! had to come right back... this time i'm trying to do a multiple insert. in my admin website i want to add users to a specific project. i...
  3. #2

    Default Re: ' & insert problem

    Sorry please ignore this question... not thinking striaght.

    R
    Dicky 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