Inserting from ASP creates 2 records instead of 1

Hi,
I'm doing an insert from an ASP page (written in VBScript) and there is a
problem.
When I call the SP from the page, it inserts 2 records into my table. If I
call the SP directly from Query Analyzer, 1 record is inserted.
I removed the oRS.moveFirst. that fixed it, but it causes other problems.
Any ways to get around this double insert crap?

please advise

Bob
Wed Feb 16 20:22:25 CST 2005

Rafael Chemtob wrote:
> Hi,
> I'm doing an insert from an ASP page (written in VBScript) and there
> is a problem.
> When I call the SP from the page, it inserts 2 records into my table.
> If I call the SP directly from Query Analyzer, 1 record is inserted.
> I removed the oRS.moveFirst. that fixed it, but it causes other
> problems. Any ways to get around this double insert crap?
>
> please advise
Use SQL Profiler to see what is going on.
--
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"