[SOLVED] Trying to create a drop down with query field

Versions are: J2.5.27, CB 2.0.3, Core Ajax 2.0.0

I have a list of zipcodes with cities.
It's imported in my DB as
kef_postnumre
But if I activate the field I get a 'SQL query' error shown.
The tabs in the query fields are:








What did I do wrong? I think I followed the example shown with the country list.

Ahh, the city is called 'by' in danish, so using that in the order statement gives me problems.
I've removed the 'by', and now I don't get an error, though I don't get the right info either.
I've removed the 'by' from the label fields.
So now I get a list of zip codes.
Is it possible to get both the zip and the city shown in the dropdown list?
Is it possible to have both values stored in the cb field? (I currently have a delimiter field doing the presentation of the two fields combined, but maybe that could be saved)

Is it possible to get both the zip and the city shown in the dropdown list?

You can get whatever information you want. Your query just needs to be correct. Test your query against your database directly using phpmyadmin (replace #__ prefix as needed for this) then see what the results are. CB Query Field will see the exact same results. For example if you need the label to contain more information then you'd CONCAT them in your query. Example as follows.

CONCAT( `field1`, `field2` ) AS label

Is it possible to have both values stored in the cb field? (I currently have a delimiter field doing the presentation of the two fields combined, but maybe that could be saved)

CB Query Select fieldtypes do store their values in the database like a normal select fieldtype. The only difference is the options come from a query.

Ahaa, I see, thanks, that made it work. Now I need to get some time to transfer the field that only contains the zipcode to a field that contains both zip and city, but it's way cooler this way I think, thankyou!