[mapserver-users] Multiple queries with PostGIS

[Diego Magni]

Dear List,

   I'm working with MapServer 3.5.1 (downloaded with Windows32 binary), 
   PostgreSQL 7.1.1 and PostGIS 0.6.2.
   I have problems for implementing multiple queries (CGI mode:
   "FEATUREQUERY" or "ITEMNQUERY") because I can't modify the filter SQL
   string via a form or a URL. After the selection of a new map file FILTER
   parameter, the PostGIS connection doesn't open the database and the error
   message appearing is

   	msPOSTGISLayerWhichShapes(): Query error. prep_DB:Error executing POSTGIS	
        DECLARE statement (0.6 failed - retried 0.5 and it failed too).

   I've tried also to build multiple queries using the CLASSITEM and
   EXPRESSION map file parameters and changing them via form. I've seen
   that it's possible to do it, but in this way you can't use complex SQL
   strings available in case of the filter change.

       How can I make multiple query with the possibility of selecting item
   and value to be searched by the user?
       In other words, can I create queries using an association
   item-value like it was possible with MapServer 3.3?

   Thank you

   Best regards

			Diego Magni