Post reply

Quote Identifier

  • March 6, 2007 at 4:05 pm

    #123137

    Hi,

    I have a web application that runs on SQL2k.  The application failed when system tries to insert data into table if the name has aspotroph on it.

    Ex. 'Sonya's Revenge'

    Will this will be taken care if I set the quote identifier on from db option?

    Please help!

    Thanks,

    Minh

  • March 6, 2007 at 4:55 pm

    #693443

    No, it won't help.

    Not using dynamic SQL and avoiding ad-hoc queries will.

    _____________
    Code for TallyGenerator

  • March 6, 2007 at 5:24 pm

    #693444

    Minh:  Search the site forums for "apostrophe", and you will get lots of useful information.

    There is no "i" in team, but idiot has two.

  • March 6, 2007 at 7:19 pm

    #693453

    Thanks for the input.  I talked to our programmer, they could easily handle that in the code by replacing single quote with double quote.

  • March 8, 2007 at 9:03 am

    #693846

    Hi ,

    use a replace function where u r populating the data into table.. e.x..

    Select Replace('abc''nhju','''','''''') or

    remove the apostrophee..from name

    Select Replace('abc''nhju','''','')

     

    Regards ,

    Amit Gupta..

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply