[thelist] Freebie ASP/StoredProc Tip

J J squid_66 at yahoo.com
Tue Jul 3 19:30:30 CDT 2001


Ah wait, just re-read the message... yes, returning a
recordset.  What do you mean by output parameter?


--- "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