[Mapserver-users] Problems with QUERY on SPATIALORACLE

[Fortin,Nicolas [SteFoy]]

Hi Fernando,

If I can find some free time, I'd be glad to be one of your betatester for this mapOracleSpatial.  I use Oracle with Mapserver 4.0.1 binary on Windows 2000 and IIS and I hope I'd be able to make query on Oracle layer soon.

Keep me in touch,
Nicolas


-----Message d'origine-----
De : Fernando S. [mailto:simon at inf.univali.br] 
Envoyé : Friday, March 19, 2004 12:06 PM
À : Gregorio Greco; mapserver-users at lists.gis.umn.edu
Objet : Re: [Mapserver-users] Problems with QUERY on SPATIALORACLE


Hi all mapOracleSpatial users,
    About the mapOracleSpatial, we (G10-LCA), intend to release a new version (1.9) with this function implemented in the next week (friday). 
    What you think about been our betatesters? We are accepting propose! We need some cases, examples where this functions are needed.
    
================================================================== 
Fernando Simon - simon at cttmar.univali.br 
================================================================== 
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer 
G10 - Laboratório de Computação Aplicada 
http://g10.cttmar.univali.br 
==================================================================

Gregorio Greco wrote: 
 
Hi All,

I have a problem with SpatialOracle and I want to do simple query for the moment like this:
I starting work with Mapserver and SpatialOracle:
now I  am successful to display  the map and to navigate,  therefore for this aspect  I do not have problems...
I have problems with 'query' o 'nquery' on data fetched from the spatialoracle tables.
I have read  that others have my same problem and I have read in a mail (21 - Jan - 2004)  that you  
are working in this function.... I would want to know  kindly  when this function will be available or if it exists another 
way for to do this.... 
I'm sorry for my little english and  I thanks in advance  who me will be able to help in this problem !
I take a small portion of code of the map file:
........ others settings ..................
_____________________________________________________________________________________________________________________________
LAYER # States polygon layer begins here
    
    NAME  province
    CONNECTIONTYPE oraclespatial
    CONNECTION "greco/9meno5=4 at test9i"

    DATA "GEOM FROM (SELECT P.PROVINCIA,P.CASI_TOT,P.GEOM FROM PROVINCE P)"

    STATUS       DEFAULT
    TYPE         POLYGON
    
 
CLASSITEM CASI_TOT

    CLASS
      NAME '141767-197144'
      EXPRESSION ([CASI_TOT] >= 141767 and [CASI_TOT] <= 197144)
      TEMPLATE 'templates/query_province.htm'
      COLOR 87 170 134
      OUTLINECOLOR 255 255 255
      
    END #end class
_______________________________________________________________________________________
.......etc etc etc........ 
 
 
Best Regards
Gregorio
 
_________________________________________________________
Dr.  Gregorio Greco
CINECA - InterUniversity Computing Center -  SISS 
http://www.cineca.it 
Via Magnanelli, 6/3  
40033 Casalecchio di Reno (BO) Italy 
E-mail:  g.greco at cineca.it 
Phone:+39-051-6171938   
_____________________________________________________