Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Unanswered: ADO parameters - multiple?

    I've got this piece of code adding 2 parameters to an ADO execution of a sql stored procedure, and it just doesn't work right.

    Code:
            kommando.CommandText = "ket.MATCH_matchnavne"
            kommando.CommandType = adCmdStoredProc
            kommando.Parameters.Append SPparam
            kommando.Parameters.Append SPparam2
            kommando.ActiveConnection = forbindelse
            kommando.CommandTimeout = 0
    All the examples I can find on the net only carry one parameter, so I'm about to go mental... if I call MATCH_matchnavn with the parameters in a query analyzer, it just runs sweetly, so there's definately something wrong.

    MANY thanks in advance,

    Trin
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Trinsan

    You are either missing loads of code there or there is no way that would ever work. I'm sure I posted on this a in the last week - was it you or someone else?
    Anyway - could you also post your parameter instantiation code?

    Ta!
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Gosh this sites search facility is rubbish - I ended up using Google to find a thread on this site.

    Anyway - turns out it wasn't you (though I did respond to one of your threads - that's what confused me) - does this help?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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