CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. August 12th, 2003, 08:03 PM #1
    vidhu
    vidhu is offline Member
    Join Date
    Apr 2002
    Posts
    35

    single quote string

    How to insert single quoted string in text field of a database
    eg:factors to Alzheimer's disease (AD)

    Thanks
    Vidhu
    Reply With Quote Reply With Quote
  2. August 13th, 2003, 11:07 AM #2
    womalley
    womalley is offline Member
    Join Date
    May 2003
    Location
    upstate NY
    Posts
    168
    escape the single quote

    What type of database are you using? Show some of the code that you are using for the insert...

    Will
    --------------------------------------------
    Tell me and I will forget
    Show me and I will remember
    Teach me and I will learn
    Reply With Quote Reply With Quote
  3. August 16th, 2003, 04:42 AM #3
    PiyuNewe
    PiyuNewe is offline Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    118

    Post

    Yes, it really depends on which database you are using.

    But u have to use Escape sequence for insertion such data in colunm.

    e.g. to insert data like

    D'Souza
    i have to type it like
    D''Souza.

    Its somewhat painful to go though all the data and replace it with double single quotes.

    But we have to do !!! no Excuse !!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured