Well Ive tried the WHERE clause and that worked I also tried removing the
group line with no success - now after delving thru a bit more and exposing
the query in dumpPGQueryResults I have found that an uppercase FROM in my
mapfile was causing problems.
I have removed that and now i get 'no results'
the next problem i have found is in squery.php::dumpPGQueryResults where the
filter is added you have the code
// Apply already existing filter on layer
$pg_filter = str_replace('"', '', $this->qLayer->getFilter());
if (strlen(trim($pg_filter)) > 2 ) {
$queryStr .= " AND $pg_filter ";
}
I changed the if clause to
if (strlen(trim($pg_filter)) > 2 && $pg_filter != "(null)")
because I have no filter defined on that layer and that was what was being
returned by $this->qLayer->getFilter()
now I still get no results because I have no column "oid" (im new to
postgis) when i removed it from the query i get results but they are dodgy
(not the right coordinates).
So next I am going to determine whether its because oid is required or
because im using DD for units or some other reason.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://faunalia.it/pipermail/pmapper-users/attachments/20060301/2455b665/attachment.htm
