[Mapserver-users] Query on Oracle Layer!?!?

[nicolas.fortin at ec.gc.ca]

Hi Fernando,

I want to do simple query for the moment like this:

I have water-level stations on my map, when querying one, I want to see
other fields of the same Oracle table (LAT, LON, IDSTN, NAME, etc) so I can
build a link to an asp page where I can't make more complex queries on other
tables (water level of the last day, max/min of the month, etc)

If it's not possible now, I have to find a way to do this...

Nicolas


-----Message d'origine-----
De : Fernando S. [mailto:simon at inf.univali.br] 
Envoyé : Wednesday, January 21, 2004 2:07 PM
À : nicolas.fortin at ec.gc.ca
Objet : Re: [Mapserver-users] Query on Oracle Layer!?!?


Nicoilas,
    Well, this function not already implemented. But we (LCA) are working in
this function. In the last year we stop to development this functions to
finish other project. Now in 2004 we intend to finish this functions. We
believe that in February or March we release this drive.
    Sorry, we stop the development but now we are retaking the development.
    But, what query are you want to execute? What do you ant show in the
map?
    
    Well, I don't know if I help you. You can see an example in this link
(http://g10novo.cttmar.univali.br/gtznovo/principal.php), everything in this
map are in OracleSpatial: 
        Shapes used in layers was passed to databases (all shapes).
        The user datas (Usuarios checkbox). 
        When you click in "Pesquisa Rio" (left menu) a new windows appear.
In this window you can write this examples: 74200000 or 83000000 or Itajai.
So after write, one list appear with you selection, when you click in the
number (link) the selected river will be show in the map.

    Sorry my poor english. And forgives the delay in the development.

================================================================== 
Fernando Simon - simon at cttmar.univali.br 
================================================================== 
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer 
G10 - Laboratório de Computação Aplicada 
Fone: 047 - 341 7960 
http://g10.cttmar.univali.br 
================================================================== 


nicolas.fortin at ec.gc.ca wrote: 
Hi list,

I just made a small application test that allow query on an Oracle Spatial
Layer.
When I made this query, I got this error :
msOracleSpatialLayerGetItems(): OracleSpatial error. Function not
implemented yet 

Doh!...So I can't make an Oracle layer queryable??


Nicolas Fortin 
Mathématicien, Programmeur, Analyste de données 
SMC-Québec Hydrologie, Environnement Canada 
1141, Rte de l'Église, Sainte-Foy(QC) G1V 4H5 
(418)648-2516 
nicolas.fortin at ec.gc.ca <mailto:nicolas.fortin at ec.gc.ca> 

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users