× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Multiple database columns in drop down box

3 năm 3 tuần trước #9916 bởi Ryan Minnig
Multiple database columns in drop down box was created by Ryan Minnig
I'm creating a component with a subform in which I want to have a drop down box that is populated with results from an SQL querry. I have chosen both the 'SQL field' and 'SQL field with extended settings' in an attempt to do this. With the more simple option I can successfully have the drop down box populated with the 'first_name' column OR the 'last_name' column but I would really like to concatenate these 2 columns into 'first_name' + ' ' + 'last_name'.
I have tried multiple combinations of SQL statements in 'SQL field' such as:
SELECT 'first_name', 'last_name' FROM #__test_people
the key field is 'id' and the value field is CONCAT(first_name, ' ', last_name)

I have also tried SELECT 'first_name', 'last_name', CONCAT(first_name, ' ', last_name) as full_name FROM #__test_people
the key field is 'id' and the value field is 'full_name'

any suggestions on how to concatenate these 2 columns using either the regular SQL field or extended options?

Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.

2 năm 11 tháng trước #9931 bởi Pete
I tried the same and got an error as well.

select prefix, CONCAT(prefix,' ') as name from #__eb_coupon

Works for me.

However a BUG - in a list thsi field do not show what has been selected, but just one value.

Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.

Thời gian tải trang: 0.045 giây
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.