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

Multiple database columns in drop down box

3 år 1 vecka sedan #9916 av 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?

Be Logga in eller Skapa ett konto ansluta till konversationen.

2 år 11 månader sedan #9931 av 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.

Be Logga in eller Skapa ett konto ansluta till konversationen.

Sidan laddades på: 0.048 sekunder
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.