[Cartoweb-users] Please help: problem with query layers.

[Xiaoyun Tang]

Hi:
Please help!

We have set up Cartoweb 3.2.0 on our server, which retrieve data from out
database (PostgreSQL) and display many dots in a the layer (mytest). It
looks great!

Now we want to query the layer (mytest) and encounter problems. We are able
to query the layer and display the data in a query result table. But when we
do it the second time without clicking on  "query_clear" button,  we got
errors:

Class : SoapFaultWrapper
Message : Attribute query returned no results. Layer: mytest,
idAttribute: taxon_id, query: taxon_id in
('NCERO0100','NCOCO0090','NCOCO0100','NCOCO0330','NCYCC0050','NCYCC0100','NCYCC0130','NDISC0030','NDISC0035','NDISC0080','NDISC0090','NDISC0100','NDISC0155','NDISC0165','NDISC0225','NDISC0300','NDISC0310','NDISC0350','NDISC0360','NDISC0465','NDISC0505','NDISC0525','NHELI0100','NHELI0140','NHELI0160','NRETI0180','NSPHN0120','NSPHN0140','NSPHN0190','NTRIQ0040')
Backtrace:

file: 254 - /mnt/md0/apache2/htdocs/cartoweb3/coreplugins/mapquery/server/ServerMapquery.php
call: ServerMapquery->queryLayerByAttributes(Object(ServerContext),
"mytest", "taxon_id", "taxon_id in
('NCERO0100','NCOCO0090','NCOCO0100','NCOCO0330','NC...", False)

file: 280 - /mnt/md0/apache2/htdocs/cartoweb3/coreplugins/query/server/ServerQuery.php
call: ServerMapquery->queryByIdSelection(Object(QuerySelection))
...
...
...

and more stack error information.

At the same time, we did a test on another layer which is generated from a
shape file, and we are able to do queries on that layer.

Here is the definition of "mytest" layer:

LAYER
  CONNECTIONTYPE postgis
  NAME "mytest"
  CONNECTION "user=xxx password=xxx dbname=xxx host=xxx"
DATA "geom from (select distinct a.geom,d.oid as oid, d.* from
neptune_hole_spatial a, neptune_hole_summary b, neptune_hole_taxa c,
neptune_taxonomy d where a.hole_id = b.hole_id and b.site_hole = c.site_holeand
c.taxon_id = d.taxon_id and fossil_group = 'N') as nanno_hole_taxa using
unique oid using SRID=4326"
  STATUS default
  TYPE POINT
  DEBUG ON
  #FILTER "taxon_id !=null"
  PROJECTION
    "init=epsg:4326"
  END
CLASS
      NAME "nanno_hole_taxa"
      STYLE
        SYMBOL "circle"
        SIZE 10
        COLOR 90 27 191
      END
  END
  TOLERANCE 100
 TEMPLATE "tt"
    METADATA
      "id_attribute_string" "taxon_id|string"
      "query_returned_attributes" "taxon_id taxon_status genus species"
   ## taxon_status, genus, species are column name in database
    END
END

Thank you for your help,
--
Xiaoyun Tang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20060316/db107786/attachment.html