How do I store multiple column values in single String?

Question

I want multiple column data inn single string variable ,I tried But I only get Single column Data,What should I do.here Is my coding ImageAnd my query is"select PRODUCT_ID_LIST from ORDERS where USER_ID=?" and code iamge is here

my table image is here

I want is that the whole column values in string and then string will be split by comma. I have split code.

score 0 · Answer 1 · answered Oct 31 '18 at 17:09

0

Very old thread but if I understood correctly, I hope we have a possible situation and at the same time solution too at this existing thread. - stackoverflow

answered Oct 31 '18 at 17:09

Ajay Kumar

2,906
3
23
46

score -1 · Answer 2 · answered Mar 14 '16 at 18:05

-1

Not sure I fully understand what you need, but look up the SQL CONCAT(...) function. It will depend on your database though if it is supported.

answered Mar 14 '16 at 18:05

Glstunna

1,993
3
18
27

When execute my code see 1 image, I only get single column in that variable.and I want I all columns data into that variable. – Yogesh Raut Mar 14 '16 at 18:08
Soooooo use '||' then? i.e. SELECT ID, Namee || " " || Family AS NameS FROM Students – Glstunna Mar 14 '16 at 20:33
Didn't get it.please write full query,I posted above. Thanks – Yogesh Raut Mar 15 '16 at 06:03
I solved it.using string builder class.thanks for helping guys. – Yogesh Raut Mar 15 '16 at 06:05

How do I store multiple column values in single String?

2 Answers2