Results 1 to 3 of 3

Thread: [2005] apostrophe handler

  1. Oct 14th, 2007, 01:51 AM #1
    jlbantang
    jlbantang is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2007
    Posts
    617

    [2005] apostrophe handler

    what is the efficient way to handle apostrophe (') when working with SQL Transact command.
    Reply With Quote Reply With Quote
  2. Oct 14th, 2007, 11:59 AM #2
    axion_sa
    axion_sa is offline
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724

    Re: [2005] apostrophe handler

    Escape it using double apostrophe's:
    Code:
    myString = myString.Replace("'", "''");
    Reply With Quote Reply With Quote
  3. Oct 16th, 2007, 08:35 AM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: [2005] apostrophe handler

    Use parameterized queries so that the apostrophes are automatically handled.
    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