[thelist] Freebie ASP/StoredProc Tip
J J
squid_66 at yahoo.com
Tue Jul 3 19:28:13 CDT 2001
Actually that example was calling a SELECT statement,
I do it all the time.
--- "Warden, Matt" <mwarden at odyssey-design.com> wrote:
> > From: "J J" <squid_66 at yahoo.com>
> > Subject: Re: [thelist] Freebie ASP/StoredProc Tip
> >
> > I don't know, I've always coded them even simpler
> than
> > that, without much performance difference:
> >
> > SQL = "EXEC myquery '" & var1 & "', '" & mydate &
> "',
> > '" & somename & "', '" & var2 & "' "
> > SET myRS = dataConn.Execute(SQL)
>
> Yeah, this is fine if you are calling an
> update/insert/delete stored proc or
> just returning a recordset, but if you need to get
> an output parameter,
> you'll need to use the method I used.
>
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
More information about the thelist
mailing list