Professional Web Applications Themes

Calling Stored Procedures! - ASP Database

I have seen number of different ways to call stored procedures in asp. Currently i am using: query : Exec sp_mystored_procedure variable1,variable2,variable3 ;cn.execute query I have seen other ado examples, just wondering if my choice of calling them is the best.? Got any examples of better ways? Thanks, AJ...

  1. #1

    Default Calling Stored Procedures!

    I have seen number of different ways to call stored procedures in asp.
    Currently i am using:

    query : Exec sp_mystored_procedure variable1,variable2,variable3
    ;cn.execute query

    I have seen other ado examples, just wondering if my choice of calling them
    is the best.?

    Got any examples of better ways?

    Thanks,

    AJ


    Anthony Guest

  2. #2

    Default Re: Calling Stored Procedures!

    Anthony Judd wrote: 

    Here's my take on this question:
    http://tinyurl.com/jyy0

    Bob Barrows
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Guest

  3. #3

    Default Re: Calling Stored Procedures!

    Thanks Bob.
    Found some great material

    AJ

    "Bob Barrows [MVP]" <SPAMcom> wrote in message
    news:phx.gbl... 
    >
    > Here's my take on this question:
    > http://tinyurl.com/jyy0
    >
    > Bob Barrows
    > --
    > Microsoft MVP - ASP/ASP.NET
    > Please reply to the newsgroup. This email account is my spam trap so I
    > don't check it very often. If you must reply off-line, then remove the
    > "NO SPAM"
    >
    >[/ref]


    Anthony Guest

Similar Threads

  1. Replies: 1
    Last Post: December 4th, 11:33 AM
  2. Calling Multiple Stored Procedures inside a cfquery
    By TMAY_CO in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 15th, 04:36 PM
  3. Calling Oracle overloaded stored procedures from CF 6.1
    By dragoshbalan in forum Coldfusion Database Access
    Replies: 8
    Last Post: July 1st, 08:25 AM
  4. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  5. Calling stored procedures from Access modules
    By Rik Hess in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 8th, 01:44 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139