Dear Justy,

Hi. I think you should double check the datatype of your variable parameters. For me, What I do first is:

1. After I create my stored procedure, I debug/test it on the query analyzer of SQL Server.

2. After that, I am now confident with my Stored Procs, I now test
with the ASP Scripts. I make sure I pass the correct parameters to
my stored proc.

This might help.


Best regards
Florencio