[mapserver-users] Color values from attribute using OracleSpatial

[Forián-Szabó Márton]

Thanks, Mike,

The detailed log was useful.

Because of multiple geometry types stored in a single table I already had a
selection in my DATA line:
DATA 'GEOMETRY FROM (select c.GEOMETRY from [table] c where
c.GEOMETRY.GET_GTYPE()=3) ...

My problem was solved when I inserted 'c.RGBCOLOR, ' before c.GEOMETRY

Márton



2011/12/17 Smith, Michael ERDC-CRREL-NH <Michael.Smith at usace.army.mil>

>  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>
> Date: Sat, 17 Dec 2011 21:45:04 +0100
> To: <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
> 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/7f267a0e/attachment.htm>