revo 2.24
IIS7.5/MS SQL
I know running SQL is not preferred in revo, but I have no direct access to the database and need to check something quick.
Something with the alias/uri is messed up, every time I turn on friendly url, navigation links some works some doesn't even show up.
I'm trying to run SQL to check for duplicate aliases
select alias, count(alias) as 'duplicate' from dbprefix_site_content group by alias having (count(alias) > 1);
xPDOCriteria looks to be what I need to use, I just can't figure out how to use it.
$query = "select ....";
$criteria = new xPDOCriteria($modx, $query);
The difficult I have is how do I get the value from the query?
It is a single integer result, not a collection.
Thanks for reading.
