Multiple/Mass Insert

Well... actually, my page(searchresults.asp) will show all the results that you searched for.. These results are from the sql server. All the datas are different. On the right of every record, there is a checkbox.

Now is the scenario..

After all records are shown, I will check a few checkboxes. Then i will click the button. All the data that is checked will be inserted in the sql server. But the thing is that all data records is different..

Its actually kinda off like the hotmail, where you checked a few boxes and put them into a different folder..

U got what i mean? I hope u can help...

First of all insert all data table into a form:
<form method="post" action="???.asp">
' Here you view results
</form>

For each result you should create an input like this:

<input type="checkbox" name="ID<%=counter%>">

at the end of the form a submit button:

<input type="submit" value="Inser data">

The ???.asp will get all the data to be inserted by
Request.Form method and insert it into the database. This will be done in a loop. In every cycle check if the checkbox IDx was checked, and if so add the data into the Recordset.

That's it.

Well this is a more detailed info...I hv a SQL server table 'spmidishad'. Theere are 7 columns. One of it is Partner.

Well, my searchresults.asp displays all the records retrived from my database (spmidishad). At the end of one row, there is a checkbox. Once a few is checked, i will press on the IMPORT button. This import button (the form action is from import.asp)
is to import (insert) all the checked records into the database.. All rows inserted (the data) are the same except for the Partner column..

Well, i want someone who can help me to figure out how I am suppose to do this..? Hope u understand what Im talking about here... Thankx..