@SELECT Binding - values

Hello all,

I have a dropbown TV with @SELECT Binding for values.

Example:
@SELECT pagetitle, id, content FROM modx_site_conttn WHERE `active`=1

my dropdown working well. when i call my TV in my template [[*tvselect]] i get the pagetitle.
Is it possible instead of only the title to get also the id as value?

if i did it like this
@SELECT id, pagetitle, content FROM modx_site_conttn WHERE `active`=1

i get the ID but i want title as well

THanks

why do you need the pagetitle as value?
You can allways get the pagetitle (and other fields of a resource) at frontend, when you have the id.

For example with fastField - tags, if you have fastField installed.

Maybe my example was wrong

I use SELECT to fetch the ids of the articles whith tv value Recomend==Yes from modx_site_tmplvar_contentvalues and Join with table modx_site_content to get pagetitle, content, etc.

http://s15.postimg.org/n9f85tcjf/Screen_Hunter_399_Feb_06_11_36.jpg - image

how i get all values?