Professional Web Applications Themes

Problem with ' in SQL Update - ASP Database

I have come across a problem with my asp pages and the database. I am working on a Employee database, and one of the fields in the DB is Address. Well this one employee happens to live on the following road, Martha's Knob Road. The problem I am having is when I try to update this record using ASP, it bombs on the 's. Is there anything that I can do, besides deleting the apostrophe and making it, Marthas Knob Road? Thanks, Drew...

  1. #1

    Default Problem with ' in SQL Update

    I have come across a problem with my asp pages and the database. I am
    working on a Employee database, and one of the fields in the DB is Address.
    Well this one employee happens to live on the following road, Martha's Knob
    Road. The problem I am having is when I try to update this record using
    ASP, it bombs on the 's. Is there anything that I can do, besides deleting
    the apostrophe and making it, Marthas Knob Road?

    Thanks,
    Drew


    Drew Guest

  2. #2

    Default Re: Problem with ' in SQL Update

    http://www.aspfaq.com/show.asp?id=2035

    Ray at work

    "Drew" <state.va.SPAMus> wrote in message
    news:phx.gbl... 


    Ray Guest

  3. #3

    Default Re: Problem with ' in SQL Update

    You replace ' with two ''

    http://www.aspfaq.com/2035

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Drew" <state.va.SPAMus> wrote in message
    news:phx.gbl... 
    Address. 
    Knob 
    deleting 


    Aaron Guest

Similar Threads

  1. Problem with IIS update
    By client crl in forum ASP.NET Security
    Replies: 0
    Last Post: February 7th, 11:39 AM
  2. Update problem with V10
    By koshington@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 0
    Last Post: March 3rd, 12:56 AM
  3. SQL Update problem
    By TomD in forum ASP Database
    Replies: 2
    Last Post: February 13th, 03:16 PM
  4. inker problem (an update to the 'general problem')
    By eRez in forum Macromedia Director 3D
    Replies: 0
    Last Post: December 29th, 12:26 PM
  5. apt-get update problem
    By Hubert Mercier in forum Debian
    Replies: 1
    Last Post: July 17th, 01:20 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