Post reply

problems with search cmd once the word has an apostrophe HELP!

  • August 8, 2008 at 9:00 am

    #93614

    Hi,

    I've created a search button that works once there is a value in the combo box. The search works fine until there is an Apostrophe in the word.

    I get a runtime error 3075 Syntax error

    HELP ! please - very urgent

  • August 8, 2008 at 9:16 am

    #855292

    The single quote (apostrophe) is a delimiter in SQL Server. You might need to escape it by passing 2 where there are one. so ...

    Select MyID from mytable where MyCol = 'It''s a good idea'

  • August 8, 2008 at 9:36 am

    #855316

    Hi Ive tried negating it by adding another single qoute mark - it doesn't come up with the error but when I click on the search button , it is not filtering and the result is blank.

Viewing 3 posts - 1 through 2 (of 2 total)

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