insert into - add multiple values in a column

[questionit]

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

[code green]

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

[ck9663]

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


--- CK

[nbiswas]

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

For Order Id 1, there can be 3 Items(say Item1,Item2,Ite m3)
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,Ite m3

2 Item1,Item2,Ite m3,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,Ite m3 for Item field.

So in that case the SQL STATEMENT will be

INSERT INTO Orders(OrderID, Items) VALUES (1,' Item1,Item2,Item3');

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


Hope this helps.