[thelist] Freebie ASP/StoredProc Tip

[Warden, Matt]

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


Thanks,


--
mattwarden
mattwarden.com