ASP - Insert Multiple records

[Yusrin]

I wanna know how to insert all the records that is checked into my SQL Server.. BUT all the records inserted is the same except for one column in my SQL Server which is the 'Partner' column..

Can someone help??

[rdove]

I'm kinda having a hard time following what it is you are trying to accomplish...

Let me see...

Are you saying that you have some checkboxes on a page and you are trying to add the records associated from those text boxes into an SQL Server database, but the records don't change?

Try to post your code so me and others might be able to see where your problem is.

[Yusrin]

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...

[putts]

There is no way to do a multiple insert with one sql string (without using a bunch of go statements).

However, I do have some very modular code to copy records from one table to another as long as the destination table has AT LEAST the same fields as the source table (though it could have more fields such as a folder name, user ID, etc. that could be set on the insert)

If you would like that code, let me know and I'll post it.

[edgarq]

Yusrin,

There is a way. I'll put together a sample for you then you can modify to suit your needs.

Reply to this email if you don't need it anymore.

Ed