read symbol angle from database

[Frank Warmerdam]

François Bruneau wrote:
> Hi,
> 
> I'm currently testing MapServer for pipes visualization purposes. This
> application includes gates objects (type point), which symbols have to be
> oriented accordingly with the pipe (type line) they're placed on.
> 
> The orientation information is available, as an angle in degrees, in my
> dataset in a column from an Oracle table. My question is : is there any way
> to combine the "ANGLE" statement in the MapFile with a SQL query? The idea
> would be to write something like :
> 
> ANGLE "ROTATION FROM table_gates"

François,

I'm not very savvy about now the oracle layer type works in MapServer,
but there is a layer keyword called "ANGLEITEM" which you can use to name
the attribute with the angle in it.  I think this should work as long
as the angle field is in your main query.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org