Thanks, I got it working. I needed to put the snippet call on the landing page!I have yet another issue
Here’s my snippet call on the landing page
[! AjaxSearch? &ajaxSearch=`0` &showInputForm=`0` &pagingType=`0` &parents=`in:24` &advSearch=`exactphrase` &withTvs=`+:business-name` !]
I am getting a sql 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 ’-name FROM `modx_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv’ at line 1 »
SQL: SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR "," ) AS tv_value, ntv1.value AS business-name FROM `modx_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `modx_site_tmplvar_contentvalues` tv ) AS ntv ON sc.id = ntv.contentid LEFT JOIN( SELECT DISTINCT tv1.contentid , tv1.value FROM `modx_site_tmplvar_contentvalues` tv1 WHERE tv1.tmplvarid = ’18’ ) AS ntv1 ON sc.id = ntv1.contentid WHERE ((sc.id IN (46,48,49,50,47,45,26,25,44,43,41,40,39,38,42,36,28,29,30,31,32,33,34,35,37)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle REGEXP ’[[:<:]]pardon[[:>:]]’) OR (sc.longtitle REGEXP ’[[:<:]]pardon[[:>:]]’) OR (sc.description REGEXP ’[[:<:]]pardon[[:>:]]’) OR (sc.alias REGEXP ’[[:<:]]pardon[[:>:]]’) OR (sc.introtext REGEXP ’[[:<:]]pardon[[:>:]]’) OR (sc.menutitle REGEXP ’[[:<:]]pardon[[:>:]]’) OR (sc.content REGEXP ’[[:<:]]pardon[[:>:]]’) OR (tv_value REGEXP ’[[:<:]]pardon[[:>:]]’) OR (business-name REGEXP ’[[:<:]]pardon[[:>:]]’))) ORDER BY sc.publishedon,sc.pagetitle
tv1 WHERE tv1.tmplvarid = ’18’ - this is the id of the tv - "business-name"
Please help!
thanks!