>> Wouldn't it be better just to send all of the data from the form to a strored proc that inserts everything into the correct tables without wasting time passing output parameters back?
It depends on what you're doing and how many times you're going to be doing it. Honestly, I'm not a fan of doing anything from an ASP page. If you're working with ASP, take a look at the WinDNA architecture.
-Mike
>Thanks for all of your help I've sorted it all out now and it works fine.
>A horrible thought has just struck me though. Why am I wasting my time doing this? Wouldn't it be better just to send all of the data from the form to a strored proc that inserts everything into the correct tables without wasting time passing output parameters back?