Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    1

    Unanswered: Newbie Question about parameters

    Hi there,

    i'm using HTTP to get XML from SQLserver 2000. I need to query the database with parameters. most of them are arrays.

    i am however unable to get any data from my database using

    WHERE name IN (@param )

    i then tried

    exec (' ....

    WHERE name IN (' + @param + ')
    ')

    and still nothing.

    Does anybody know what i'm doing wrong?


    Thank alot

    Wim Horemans
    p.s. in @param there should be something like "jef, jan, gert, dunno"

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Your local variable should look like "'jef', 'jan', 'gert', 'dunno'"

    and your where caluse should evaluate to

    exec (' ....

    WHERE name IN ('jef', 'jan', 'gert', 'dunno')
    ')
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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