the OID field is for sure required, as it is used as the index to the
records. For what strange reasons whatsoever the Postgres developers removed
the default creation of an OID field in version 8.1. For your tables you had
to create them with 'WITH OID' at the end.
armin
>
> Well Ive tried t
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 result
Hi
I have been trying to get the search function working on my map for a few
days now I have read all the previous posts I could find on the list and I
have read the comments in js_custom.php and scrutinised the demo map file
with no success.
I am using postgis and pmapper 1.1 could someone pleas
What is the result? 'No records found'? or a PHP error (maybe in the error
log)?
You can display the query WHERE clause uncommenting the line 649 in
query.php (echo $this->qStr;) try to run this SQL then on your database
(adding the SELECT... FROM... before) and see if this query gives you any
res
