[Chameleon] LocateByAttribute in Postgis

[Fons Arts]

Hi list,

 

I am added the latest widget (from CVS) locatebyattribute to zoom to values
stored in a  Postgis database.

In this test I'm searching for the value OLO00 A 1037 witch exist in a view.
After clicking the search button I get no results.

 

Warning: [MapServer Error]: msQueryByAttributes(): No matching record(s)
found. in
E:\ms4w\chameleon\htdocs\widgets\LocateByAttribute\searchresults.phtml on
line 361

No results found for 'OLO00 A 1037'

----------------------------------------------------------------------------
----

  kadastraal nummer   aanduid    Find  

Limit search to current map extents  

 

 

My Map file looks like;

 

                        LAYER

                        CONNECTIONTYPE postgis

                        NAME "kadastraal nummer"

                        GROUP "Eigendommen"

                        CONNECTION
*************************************************************

                        DATA "wkb_geometry from (select oid, aanduid,
eigenaar, wkb_geometry from public.v_kadaster where aanduid = 'OLO00 A
1037') as foo using srid=-1 using unique aanduid"

                        TEMPLATE "dummy.htm"

                        TOLERANCE 10

                        MINSCALE 0

                        MAXSCALE 20000

                        STATUS default

                        TYPE polygon

                        METADATA 

                                   SPATIALSEARCH "aanduid"

                        END

                        CLASS

                        NAME 'string'

                                   SIZE 22

                        COLOR 253 239 221 

                                   outlineCOLOR 255 255 0 

                            MINSCALE 0

                        END

            END 

                        END  # LAYER

 

Anybody tips

Thanks

Fons

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/chameleon/attachments/20061031/e54ce766/attachment.html