[postgis-users] problem in dynamic SQL with Mapserver

[nimalika fernando]

Hi Drew,
   
  thank you for your help Drew,
   
  But still i am not successful in this query. Modified query 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.
  can anybody help me to figure out a solution , pls?
  
thank you in advance,
   
  Nimalika


 
---------------------------------
Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070227/630c4e10/attachment.html>