insert into - add multiple values in a column

Hi

How do i write multiple values in a single column, using INSERT INTO

I have a listbox and i want all the selected values from that listbox inserted into a table column

INSERT INTO Orders(OrderID, Items) VALUES ____?????________

Do i need to run the above statement in a loop?

Thanks
qi

re: insert into - add multiple values in a column

re: insert into - add multiple values in a column

If you need to have all the selected from your listbox in different rows, yes you need to issue multiple insert statements.


--- CK

re: insert into - add multiple values in a column

As far as I understand, the problem is something like this.

For Order Id 1, there can be 3 Items(say Item1,Item2,Item3)
For Order Id 2, there can be 5 Items(say Item 1.. Item5, all are comma seperated).

Next you want to insert the values into your database table

So the output will be like

TblOrders

OrderID Items
---------- --------
1 Item1,Item2,Item3

2 Item1,Item2,Item3,Item4,Item5

If that is supposed to be the case, handle all the list box items from your Frontend applications all at a time.

I mean to say before passing to the SQL QUERY, you should send the values as, 1 for OrderId filed while Item1,Item2,Item3 for Item field.

So in that case the SQL STATEMENT will be

You don't have to write any loop in the STORED PROC . Handle from your Frontend application.


Hope this helps.