display one column in a list from a table in sql database

[Yamaeda]

---

@mfaizolmi wrote:

Hi Logan,

Thanks for the suggestion...

what i need is only one column to be displayed inside a list which will be used as a control... Below is the list box i wanted... the displayed items are the in the same column... i tried your method, but it can only display the first item "kebab"..... but the interface of the one you suggest is not like in the image attahced...

i did try the sql-style query, but nthing change..... anyway, what do you mean by the sql-style query? do i need to use "EXECUTE" block...?

---

But you do get a result? What if you drop an array indicator and show the result, could it be the resulting array needs transposing?

/Y

[dkfire]

Are you sure that the select statement is correct?

[mfaizolmi]

Hi all,

thanks for all of your kind reply and help. i already found the solution for my problem and with this reply, i attached the image of my solution...

the solution i was looking for is in the file "block diagram for list box", while the other one is my test vi for this solution...

thanks for your help...!!