//Template for each search result 'result' => ' <div class="[+as.resultClass+]"> <a class="[+as.resultLinkClass+]" href="[+as.resultLink+]" target="_blank">[+as.longtitle+] | [+as.pagetitle+]</a> [+as.description+] [+as.extract+] </div>',
$qry_sql = "sc.privateweb = 0 AND ";
$qry_sql = "sc.privateweb >= 0 AND ";

$sql .= $qry_sql . "sc.published = 1 AND sc.searchable=1 AND sc.deleted=0;";
$sql .= $qry_sql . "sc.published = 1 AND sc.searchable=1 AND sc.deleted=0 AND sc.contentType='text/html';";
Not sure what kind of example you are looking for, but here is a screenshot of some data returned from an OsCommerce database that I’d like to be able to search on.
As I think more about this, I expect it to be difficult to achieve this from within MODx.
Maybe I can hook into the OsCommerce search...
If I am overlooking something or if someone has experience with this they would like to share, it would be great.
Cheers,
Andreas

This discussion is closed to further replies. Keep calm and carry on.