Post reply

SQL query problem

  • February 27, 2006 at 10:27 pm

    #111982

    i have a DB column field {name,exception}

    it has a value :

    name | exception

    ==========================================================================================================================================

    orkut | WebL exception: [. "msg" = " function expects a page or piece as first argument", "type" = "ArgumentError", "line" = 320 .]

    i am wrinting a SQL query like this in the Query Analyzer

    select * where exception LIKE 'WebL exception: [. "msg" = " function expects a page or piece as first argument", "type" = "ArgumentError", "line" = 320 .]'

    but this does not produce any result.

    what i have to do ?

  • February 28, 2006 at 7:34 am

    #623682

    You will need to use a wildcard statement like so

     

    select * where exception LIKE '%WebL exception: [. "msg" = " function expects a page or piece as first argument", "type" = "ArgumentError", "line" = 320 .]'

     

    so it knows to look no matter what is at the beginning. If unfamiliar see LIKE in SQL Books Online.

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

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