problem in Dynamic query with postGIS

[J. Parapar]

 Nimalika:

 For PostGIS the FILTER parameter must be set to a valid SQL WHERE clause like

 id=1 (numeric field)

 or

 name='Lugo' (string field)

 And you do not have to set the FILTERITEM parameter.

 Best regards
 Jorge


2007/3/6, nimalika Fernando <nimalikaf at yahoo.com>:
> Hi,
>
> Thank you very much for the guidence
> Actually I tried with QUERYMAP and can get the work done if use data from
> shape files , through a filter.
>
> But I am not clear about how to do the same using data in postGIS. My
> requirement is to use data in the database.
>
> can you please help me on using QUERYMAP and postGIS query together ?
> Any help is highly appriciated.
>
> best regards
>
> nimalika
>
>
> On Fri, 2 Mar 2007 15:16:52 +0100, J. Parapar <listario at GMAIL.COM> wrote:
>
> >  Nimalika:
> >
> >  It seems that in the qstring parameter you are specifying only the
> >name of the village and not a condition like
> >qstring=dsd_n='Ambalanthota. This results in an incorrect SQL
> >condition.  Changing this affects the use you do of qstring as a
> >variable in DATA. I think you should try again with QueryMap, it is a
> >simpler way to  get the results of the query highlighted in the map.
> >
> >  Best regards,
> >  Jorge
> >
> >
> >2007/3/1, nimalika Fernando <nimalikaf at yahoo.com>:
> >> hi everybody,
> >>
> >> I am working in a disaster recovery application  , using Mapserver and
> postGIS
> >> for mapping part.
> >>
> >> I need to implement a simple search facilty, for eaxmple if user already
> knows
> >> a village affected , by selecting that village name using a combo box in web
> >> interface the related village should be highlighted in the map.
> >>
> >> I am not clear about how to implement such but I tried several options.
> >> I have used a QUERYMAP object and tried . But I am not getting the work
> >> done. My data resides in postGIS db and working with Maapserver in CGI
> mode
> >> is fine for basic operations.
> >> My query in the map file  is as follows
> >>
> >> DATA "the_geom from (select alldsdivisions.the_geom as
> >> the_geom,alldsdivisions.gid as oid ,
> >> alldsdivisions.dsd_n as  dsd_n from alldsdivisions
> >> where alldsdivisions.dsd_n ='%qstring%')
> >>
> >> error mesage I get is as follows
> >>
> >>  prepare_database(): Query error. Error executing POSTGIS DECLARE (the
> >>  actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> >>  dsd_n::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),oid::text
> >> from (select alldsdivisions.the_geom as the_geom,alldsdivisions.gid as oid ,
> >> alldsdivisions.dsd_n as dsd_n from alldsdivisions where alldsdivisions.dsd_n
> >> ='Ambalanthota') AS selectedgs WHERE (Ambalanthota) and (the_geom &&
> >> setSRID( 'BOX3D(181659.373889 74242.41425975,303213.047119
> >> 165407.66918225)'::BOX3D,-1) )'
> >>
> >> Postgresql reports the error as 'ERROR: column "ambalanthota" does not
> >> exist '
> >>
> >> here , "Ambalanthota" mean a value of coumn dsd_n of table
> >> alldsdivisions. qstring is replaced by the user selected value of the combo
> box.
> >>
> >> I have tried to get help from postGIS users but still i couldn't solve this
> >>
> >> can anybody help me to figure out a solution , pls?
> >>
> >> thank you in advance,
> >>
> >> Nimalika
> >> from Sri Lanka
> >>
>