Roji. P. Thomas wrote:
1. a RETURN value and OUTPUT value are differenct.
2. You can only RETURN an integer value.
3. Your SP RETURNS and OUTPUTS the count value.
To see how to use them from ASP, read
http://www.adopenstatic.com/faq/reco...ternatives.asp
and http://www.adopenstatic.com/faq/SprocsAndParameters.asp
The second FAQ article is very relevant. The only thing I have to add is
that stored procedure code generators exist. There's been a VB Addin
available for years that generates the VB code needed to create a Command
object and build the Parameters collection. I adapted that Addin, fixing a
couple deficiencies along the way, to enable it to generate the equivalent
vbscript code. It is available here:
http://www.thrasherwebdesign.com/ind...asp&c=&a=clear
Since you will have the source code, you will be able to modify it to do
what you want (say, for example, you don't like the variable names I used:
modify the vbscript to use your variable names.)
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"