Thanks, Mike,<br><br>The detailed log was useful.<br><br>Because of multiple geometry types stored in a single table I already had a selection in my DATA line:<br>DATA 'GEOMETRY FROM (select c.GEOMETRY from [table] c where c.GEOMETRY.GET_GTYPE()=3) ...<br>
<br>My problem was solved when I inserted 'c.RGBCOLOR, ' before c.GEOMETRY<br><br>Márton<br><br><br><br><div class="gmail_quote">2011/12/17 Smith, Michael ERDC-CRREL-NH <span dir="ltr"><<a href="mailto:Michael.Smith@usace.army.mil">Michael.Smith@usace.army.mil</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>Márton,</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>You also don't specify your version. </div>
<div><br>
</div>
<div>I have tested this on MapServer 6 and an Oracle Spatial connection and not had any issue.</div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
<div>
<div>
<div>
<div>-- </div>
<div>Michael Smith</div>
</div>
<div>US Army Corps</div>
<div>Remote Sensing GIS/Center</div>
</div>
</div>
<span>
<div style="font-family:Calibri;font-size:11pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>Forián-Szabó Márton <<a href="mailto:mforiansz@gmail.com" target="_blank">mforiansz@gmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Sat, 17 Dec 2011 21:45:04 +0100<br>
<span style="font-weight:bold">To: </span><<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>[mapserver-users] Color values from attribute using OracleSpatial<br>
</div><div><div class="h5">
<div><br>
</div>
Hi,<br>
my problem when using attributes for color values with OracleSpatial:<br>
RGB color values are defined as a string like '0 128 211' in a column named 'RGBCOLOR'.<br>
The map file looks like<br>
... <br>
STYLE<br>
COLOR [RGBCOLOR]<br>
...<br>
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:<br>
OracleSpatial error. Error: ORA-00904: "RGBCOLOR": invalid identifier<br>
<br>
Thanks for any suggestions!<br>
<br>
Márton Forián-Szabó<br></div></div>
_______________________________________________ mapserver-users mailing list <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">
mapserver-users@lists.osgeo.org</a> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">
http://lists.osgeo.org/mailman/listinfo/mapserver-users</a> </span>
</div>
</blockquote></div><br>