Márton, You can use DEBUG mode (DEBUG 3 or higher on the LAYER) to see in your error log the exact query that MapServer is generating. The fact that you are seeing an ORA-00904 for RGBCOLOR as an invalid identifier indicates that the column request is being passed to Oracle but that your column in your table must have a different name.
You also don't specify your version. I have tested this on MapServer 6 and an Oracle Spatial connection and not had any issue. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center From: Forián-Szabó Márton <[email protected]<mailto:[email protected]>> Date: Sat, 17 Dec 2011 21:45:04 +0100 To: <[email protected]<mailto:[email protected]>> Subject: [mapserver-users] Color values from attribute using OracleSpatial Hi, my problem when using attributes for color values with OracleSpatial: RGB color values are defined as a string like '0 128 211' in a column named 'RGBCOLOR'. The map file looks like ... STYLE COLOR [RGBCOLOR] ... Trying this with Shape+dbf files the coloring of the shapes works properly, but when the data is in OracleSpatial and I reference to the 'RGBCOLOR' column in the same way I receive: OracleSpatial error. Error: ORA-00904: "RGBCOLOR": invalid identifier Thanks for any suggestions! Márton Forián-Szabó _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
