[mapserver-users] Color values from attribute using OracleSpatial

[Smith, Michael ERDC-CRREL-NH]

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 <mforiansz at gmail.com<mailto:mforiansz at gmail.com>>
Date: Sat, 17 Dec 2011 21:45:04 +0100
To: <mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>>
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 mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111217/2dab6c5b/attachment.htm>