Why won't this work in a dbjoin

[lazysheepmedia]

Guys

A CONCAT query for a dbjoin element

{thistable}.ten_reg_name,' ',{thistable}.ten_reg__last_name

This is working fine on another form but when I try to add it to another form i get the following errors

Unknown column 'tenants_reg.' in 'field list' SQL=SELECT DISTINCT(`tenants_reg`.``) AS value, CONCAT(tenants_reg.ten_reg_name,' ',tenants_reg.ten_reg__last_name) AS text FROM `tenants_reg` AS `tenants_reg` ORDER BY text ASC

Can anyone help please?


Thanks

 

[lazysheepmedia]

Fixed it

The problem I think is when I select a column - for example ten_reg_name - from the table, it works ok - When i then go to edit the element again the drop down to select "Value" & "Label" is not loading the data from the column

I have to then choose another table and re-select the table I want the data to display - it then loads the "Value" & "Label" info

Hope that makes sense?? ??????

 

[cheesegrits]

I can't duplicate the issue with dropdowns for value and label losing their settings.

Are you seeing any JS errors, either when loading or saving the page?

Most common cause for this is if there is an error when building the dropdowns as part of the AJAX calls when the page loads. Usually something like a PHP notice being thrown, which causes the returned JSON response to be invalid.

-- hugh