[Users] Need help in form based searching from PostGIS database to zoomin the map

[Jehanzeb Orakzai]

Hi,
I am using GeoExt, ExtJS, and OpenLayers to develop the front end for web mapping, GeoServer to serve maps as WMS and WFS & PostgreSql/PostGIS for database having spatial and non-spatial data.
I have cities & school data as point in their respective tables in the database which are publish through GeoServer. School table is linked with cities using cityID.
I want to develop a form that contains cities as text box and school as dropdown loaded from the database, so that a user can perform search on it and the map is zoomed to that particular area with non-spatial information display in a separate grid.
I don’t know how to load the data in the combo box / dropdown from the DB using the above software stack and perform some searching. How to zoom to a particular location based on the criteria and display non-spatial data in grid.
I need some guidelines or examples for the problem stated above.
Can somebody help me in achieving this?
Any help is appreciated.


 
Thank you,
--
Jehanzeb


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.geoext.org/pipermail/users/attachments/20100718/cb7675dd/attachment.htm