TV binding @SELECT : different value/name

- 167 Posts
johnxx Reply #1, 11 years, 5 months ago
Is there a way to use @SELECT in order to populate a TV list with specific columns for displayed names and values ?

Something like:
```
@SELECT `name` FROM `[[+PREFIX]]wdata_country`==@SELECT `id` FROM `[[+PREFIX]]wdata_country`
```
MODX lover
-
Développeur MODX / Webdesign / Solutions web
- 128 Posts
Michael Engel Reply #2, 11 years, 4 months ago
It has to be one Query, just select two fields the name will be visible, id the value
```
@SELECT `name`, `id` FROM `[[+PREFIX]]wdata_country`
```
http://rtfm.modx.com/revolution/2.x/making-sites-with-modx/customizing-content/template-variables/bindings/select-binding