[Chameleon] retrieving postgis data programmatically

[Anand Akmanchi]

Hi friends

i am trying to develop a widget which displays a popup containing combos
where one provides inputs for retrieving a layer from postgis database

so far i have been able  to display the popup with the required combos
and when i click on OK,
the popup submits the form to itself
the combo selections are read and an SQL query is built correctly

in the mapfile i have a layer which looks like this
LAYER
DATA the_geom from (%SQL%) AS foo USING UNIQUE gid USING SRID=32643

my question is how do i send the built SQL query to the mapfile and
update the map?

im stuck here
please help


-- 
Anand Akmanchi
PhD Student, Department of Environmental Science
University of Pune
http://www.unipune.ernet.in/dept/geography/anandakmanchi.htm