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

Multiple database columns in drop down box

3 года 3 нед. назад #9916 от Ryan Minnig
Ryan Minnig создал тему: Multiple database columns in drop down box
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?

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

2 года 11 мес. назад #9931 от Pete
Pete ответил в теме Multiple database columns in drop down box
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.

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

Время создания страницы: 0.046 секунд
Работает на Kunena форум

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.