I was thinking of something like this for your data statement: DATA "the_geom from (select w.majwsh_geom as the_geom, w.oid as oid, w.name from watershed as w) using unique oid using srid=26915"
A more basic question for you: Is your geometry column really named 'topology' and your table name really 'tablename'? Before you try to query this layer or get it to be served in a WMS, can you just get the geometry to draw on the map? David. -----Original Message----- From: Subha Ramakrishnan [mailto:[email protected]] Sent: Friday, March 13, 2009 10:13 AM To: Fawcett, David Cc: Steve Lime; [email protected]; [email protected] Subject: Re: [mapserver-users] NQuery problem Hi David, Thanks a lot for the reply. It would be great if you can give me an example url. Thanks & regards, Subha Fawcett, David wrote: > Subha, > > In taking a quick look at your layer, I think that you have a problem > with your data statement. I am quite sure that if you want to use an > attribute(column) from your data layer for classification or query > results, you need to explicitly include the name of that column in the > select query that is in your data statement. > > David. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Subha > Ramakrishnan > Sent: Friday, March 13, 2009 1:44 AM > To: Steve Lime > Cc: [email protected]; [email protected] > Subject: Re: [mapserver-users] NQuery problem > > > Hi > > Here's how the layer looks in my mapfile: > layer > name abc > connectiontype postgis > connection "user= user dbname=xyz host=localhost" > type point > tolerance 20 > group world > dump true > METADATA > "wfs_title" "Factbook Metadata" > "gml_include_items" "all" > "wms_feature_info_mime_type" "text/html" > END > template "template.html" > projection > "init=epsg:4326" > end > transparency 65 > status on > data "topology from tablename using unique id using SRID = -1" > classitem "veg_class" > class > name "AGRICULTURE" > expression "AGRICULTURE" > style > symbol 'custom_icon' > size 20 > color 179 189 209 > outlinecolor 000 000 000 > end > end > end > > Status is on and template is defined. > Am i missing something else? > > Thanks a lot for the help. > > Subha > Steve Lime wrote: > >> For a layer to be queryable you have to: >> >> 1 - either set Status DEFAULT, or explicitly turn it on (e.g. >> > layer=abc) > >> 2 - define the layer TEMPLATE property >> >> Are those true? >> >> Steve >> >> >> >>>>> Subha Ramakrishnan <[email protected]> 03/13/09 12:38 AM >>> >>>>> >>>>> >> Hi, >> >> I am also facing a similar problem. It doesn't throw an error but it >> doesn't give me a result either. >> >> My url looks like this : >> http://localhost/cgi-bin/mapserv?MAP=abc.map&MODE=nquery&LAYERS=abc&im >> gext=8920506.9477+3496535.4213+8954750.736418456+3530779.2100573704&im >> gbox=657+209+686+239&imgxy=670+230 >> >> The extent given here is within the map extent. >> Can you please tell me if there's some mistake here? >> >> Thanks a lot. >> >> Subha >> >> Steve Lime wrote: >> >> >>> Nquery doesn't require qstring validation. What does your URL look >>> like? >>> >>> Steve >>> >>> >>> >>> >>>>>> Rui Gomes <[email protected]> 03/12/09 9:42 PM >>> >>>>>> >>>>>> >>>>>> >>> I try to use the nquery function and i recived the follow error >>> message: >>> >>> mapserv(): Web application error. Metadata >>> qstring_validation_pattern >>> > > >>> is not set. >>> >>> To avoid this i insert in the mapfile the follow lines inr the layer >>> i want to query: >>> >>> >>> METADATA >>> qstring_validation_pattern '.' >>> END >>> >>> >>> What this lines means. Why i have to put it? >>> >>> Thanks >>> >>> >>> >> >> >> > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
