Hello,
I was trying this TV method using @DOCUMENT binding instead of chunks. Something like this:
Input Type: Listbox (Multi-Select)
Input Option Values: Option1==@DOCUMENT 64 || Option2==@DOCUMENT 65
It works fine when only one option is selected (option1 or option2), it also works fine when no option is selected. But, when I select both options I get the following error:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’65) AND sc.published=1 AND sc.deleted=0 ) AND (sc.privateweb’ at line 3 »
SQL: SELECT DISTINCT sc.* FROM `modx`.`modx_site_content` sc LEFT JOIN `modx`.`modx_document_groups` dg on dg.document = sc.id WHERE (sc.id IN (64 ||@DOCUMENT 65) AND sc.published=1 AND sc.deleted=0 ) AND (sc.privateweb=0) GROUP BY sc.id LIMIT 1
I don’t know, maybe it’s not possible to use @DOCUMENT bindings with TVs?
Your help will be appreciated.
Regards.
Since using modX this is how I have been sorting my sidebar but using a text area and manully re arranging my chunks...
I have adopted this method of multiselect BUT now i cant then order the sidebar blocks to my liking.. is there any perams i can use to do this?
Also, i have a category of chunks called sidebar content, can i not just let the TV automatically pick all the chunks from there or do i have to keep going back to my TV and manually entering the blocks when i add a new one?
