SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    calling a stored proceedure

    hello,
    I am having a bit of problems with MS SQL server stored proceedures.

    When i create them in Enterprise manager. and give them the appropriate execute permissions.

    I then try to pass the variables in my asp page and call it by name in the commands object command text.

    But nothing happens

    please advices

    thanks

  2. #2
    SitePoint Addict markchivs's Avatar
    Join Date
    Oct 2004
    Location
    Malvern Hills, UK
    Posts
    233
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Psychic code debugging hasn't been perfected on this forum yet, put your ASP code up here and someone will have a look.



  3. #3
    SitePoint Enthusiast RageMan's Avatar
    Join Date
    Apr 2004
    Location
    Australia
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It hasn't?!

  4. #4
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi,
    just figured out a solution
    i use query analyzer, and use the error messages.

    enjoy


Bookmarks

Posting Permissions

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