Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zippy
Yak Posting Veteran
69 Posts |
 Posted - 2001-10-17 : 20:44:29
|
| Hi,Im using asp to take update my database.I have a whole bunch of checkboxes, the values of which need to be put into the database in a two column table(PersonID, CatID)So if person 5 checks 1, 2 and 3 then it will update the database so that it looks like thisPersonID | CatID5 | 15 | 25 | 3I will be using a stored procedure to do this,1. can i just pass in a CSV and loop it inside the sproc?or 2. should i just loop through executing the sproc in asp?if 1. how?I have looked at this http://www.sqlteam.com/item.asp?ItemID=256 article, but cant say I completely understand it...Please help :)Check out the worlds fastest computers at http://www.ocgurus.com |
|
|
|
|
|
loop insert