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 <[EMAIL PROTECTED]>:
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
