AW: [UMN_MAPSERVER-USERS] Oraclspatial OGR+OCI FeatureInfoRequest

[Böcke, Max (init)]

Thanks. 
I've found the mistake. It was an error in the database table.
Important is, that you have to write an entry in the database or mapfile.
You need an Primary Key named OGR_FID in your table.
Here my Configuration:
LAYER
   NAME "Badeg"
   TYPE POINT
   STATUS DEFAULT
   CONNECTIONTYPE OGR
   CONNECTION "OCI:user/pass at DbName"
   DATA "select ID as OGR_FID, geometrie, Name, Gemeinde, Kreis from hydbasis_badegewaesser"
   #MAXSCALE 300001
   HEADER "Templates/Badegewaesser_header.html"
   FOOTER "Templates/Badegewaesser_footer.html"
   TOLERANCE 10
        CLASS
          SYMBOL 3
          COLOR 0 0 200
          SIZE 4
          TEMPLATE "Templates/Badegewaesser_query.html"
        END
        
END

Greetings

Max Böcke

-----Ursprüngliche Nachricht-----
Von: bluecarto at free.fr [mailto:bluecarto at free.fr]
Gesendet: Mittwoch, 24. November 2004 11:44
An: Böcke, Max (init)
Betreff: Re: [UMN_MAPSERVER-USERS] Oraclspatial OGR+OCI
FeatureInfoRequest


A bug has been reported for the same issue I think.

http://208.24.120.44/show_bug.cgi?id=657

Pierre GIRAUD
camptocamp.com

Selon "Böcke, Max (init)" <Max.Boecke at INIT.DE>:

> Hello Community,
>
> I've got a little problem. I try to have a FeatureInfoRequest using
> ....
> Connectiontype OGR
> Connection "OCI:user/pw at db"
> ....
>  My Mapfile_Layer_configuration:
>
> LAYER
>    NAME "Badegew"
>    TYPE POINT
>    STATUS DEFAULT
>    CONNECTIONTYPE OGR
>    CONNECTION "OCI:xxxx/xxx at xxx"
>    DATA "wab_staedte_umn"
>    #MAXSCALE 300001
>    HEADER "Templates/staedte_header.html"
>    FOOTER "Templates/staedte_footer.html"
>    LABELITEM "Name"
>    TOLERANCE 3
>     CLASS
>      SYMBOL 7
>      COLOR 255 0 0
>      SIZE 5
>      TEMPLATE "Templates/staedte_query.html"
>
>           LABEL
>             COLOR 0 0 0
>             SIZE TINY
>             POSITION UC
>           END
>     END
>
> END #End Layer
>
> When the InfoRequest is shown in the IE, the mapserver send back the first
> entry from the oracle spatial table, whatever I 've snapped in the Map. He
> shows the same entry of the DB table.
> Sorry for bad english.:-(
>
> regards from Berlin (Germany)
>
> Max Böcke
> [------------------------------------------------------------------
> ]init[ Aktiengesellschaft                Rosenthaler Strasse 13
> für digitale Kommunikation               D-10119 Berlin
> http://www.init.de/                      tel: +49 (30) 97 006 259
> mailto:Max.Boecke at init.de           fax: +49 (30) 97 006 459
> ------------------------------------------------------------------]
>