I have a listbox (multiple) inside a MIGX tv I put together. But I’m having trouble with the output. I have a need for a dropdown of all attorneys in our database so I can output specific items from their bios.
To do this, I used this for my InputOptionValues in my TV:
pagetitle, attorney.id AS
attorneyLEFT JOIN modx_site_tmplvar_contentvalues tlastnamevalue ON tlastnamevalue.contentid = attorney.id AND tlastnamevalue.tmplvarid = 10 WHERE
published= 1 AND
deleted= 0 AND (
parent= 1 OR
parent= 2 OR
parent= 3 ) ORDER BY
This got me my list, but when I use it, all I’m getting as a result is the resource ID (which is expected). However, what isn’t expected is that when I select multiple items, it combines the resource IDs rather than showing a delimiter.
Instead of 22,23 or 22||23, I’m getting 2223.
Any ideas on how to fix this? I tried searching for this and only found an unanswered article I posted from 2 years ago. >_<