[thelist] ASP vs TSQL

Norman Beresford n.beresford at anansi.co.uk
Thu May 23 05:44:01 CDT 2002


Hi all

I'm writing a bit of code which is going to update fields in a table.
Bascially a form with checkboxes is submitted, each checked checkbox
represents a record which needs to be updated.  Now before I would have used
ASP to loop through an array generated from the returned value of the
checkboxes, with each iteration altering the value of a parameter and
executing a command.  What I was thinking was that instead of doing this,
perhaps I would be better off just passing the array through to a stored
procedure and allowing it to loop through it.  Resulting in one call to the
database, rather then repeated ones.  Would this be a good idea?

Norman




More information about the thelist mailing list