This thread should be turned into a documentation bug in Trac then. Huub, can 
you take care of that?

  http://trac.osgeo.org/mapserver

Steve

>>> Huub Fleuren <[EMAIL PROTECTED]> 9/15/2008 5:36 AM >>>
Hi List,

I was looking for parameter syntax when using native Oracle support.
I found in the documetation a PDF from 2004 or 5 telling all about FUNCTION and 
VERSION, but i couldn';t get it right and was very unhappy about it

But then i looked in the source  file (maporaclespatial.c) and found the 
follwing short notice
 *****************************************************************************
 *
 * Using OracleSpatial:
 * - CONNECTIONTYPE oraclespatial
 * - CONNECTION 'username/[EMAIL PROTECTED]'
 * - DATA 'geometry_column FROM <table>'
 *   or
 *   DATA 'geometry_column FROM <table> [USING UNIQUE <column>' SRID #srid 
<function> VERSION <vcode>]'
 *       <function> can be:
 *           'FILTER', 'RELATE', GEOPMRELATE' or 'NONE'
 *       <vcode> can be:
 *           '8i', '9i' or '10g'
 * 
 *       <table> can be:
 *            One database table name
 *       or:
 *            (SELECT stmt)
 *
 *****************************************************************************
 * Notices above shall be included in all copies or portions of the software.
 * This piece is provided "AS IS", without warranties of any kind. Got it?
 *****************************************************************************/ 



Looks clear to me, and surprizingly it answered all my questions to 
satisfaction.
So, please whoever manages that part now, start the extensive PDF help info 
with this.

Regards, Huub


p.s. i have a small extra:

 In 
*   DATA 'geometry_column FROM <table>

<table> can or sometimes  must be a select query in brackets 
 
e.g.

SELECT geom FROM (select geom,id from geo_table)  USING UNIQUE id SRID 123123 
RELATE VERSION 10g


_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to