<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; 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 id="OLK_SRC_BODY_SECTION">
<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">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">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><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>
_______________________________________________ mapserver-users mailing list <a href="mailto:mapserver-users@lists.osgeo.org">
mapserver-users@lists.osgeo.org</a> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">
http://lists.osgeo.org/mailman/listinfo/mapserver-users</a> </span>
</body>
</html>