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

Re: Calling Stored Procedures!

Anthony Judd wrote:
> 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

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"

Re: Calling Stored Procedures!

Thanks Bob.
Found some great material

AJ

"Bob Barrows [MVP]" wrote in message
news:OfgOVPSrEHA.3848@TK2MSFTNGP14.phx.gbl...
> Anthony Judd wrote:
> > 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
>
> 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"
>
>