I had been trying in vain for hours trying to get a simple evaluation query displaying in Mapserver. It wasnâ€™t as if postgis never worked, in fact the other 20 layers in the mapfile worked flawlessly. Just this little sucker ..
CONNECTION â€œhost=localhost dbname=adsf user=chris password=â€
DATA â€œthe_geom FROM pgmrsâ€
NAME â€˜Central City Areaâ€™
EXPRESSION (â€™[desc]â€™ eq â€˜Central City Areaâ€™)
COLOR 102 153 255
OUTLINECOLOR 102 153 255
Spot the problem yet?
DESC is a reserved keyword for pretty much everything SQL, but alas it had completely slipped my mind. When mapserver passes the CURSOR SELECT statement, it still sends the desc::text and postgre throws an error, its just a shame it isnt a â€œmeaningful errorâ€
So theres another tip to add to your â€˜doh, i cant believe i did thatâ€˜ list
Now all i need to do is figure out why ms4.4.2 still doesnt like it when 4.6&4.8 both work