[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