Saving data to a SQL Server 2000 database

I have a form that users can add links to via a popup. When the user adds a link from the pop开发者_如何学运维up the link appears in the form however I do not want the link path saved to the database unless the user saves the form.

The user can add as many links as they like. How would you recommend handling this? I thought about passing a delimited string of link paths to the stored procedure when saving the form.

Does this sound like a good idea? I'm thinking max character count could be a problem. Any ideas?

Sounds like you need a Links table that has a one-to-many relationship to the rest of the form saved data. In your stored proc, you can loop through the passed data and do an insert to this table for each properly formatted link.