Thank you for the quick response. Now works fine for type Suggest but for type option it dose not work.
This is my inline search.xml -------------------------------------------------------------------------------------------------- <searchitem name="Utility_and_services" description="Utility and services suggest"> <layer type="postgis" name="Utility_and_services"> <field type="s" name="name" description="Utility and services suggest" wildcard="2"> <definition type="suggest" connectiontype="db" minlength="1" startleft="1" sort="asc" dependfld="gid"> <dsn encoding="UTF-8">pgsql://postgres:postgres@localhost:5432/template_postgis_20</dsn> <sql>SELECT DISTINCT name FROM public.tbl_utility WHERE name ~* '^[search]' ORDER BY name</sql> </definition> </field> </layer> </searchitem> <searchitem name="ward" description="ward"> <layer type="postgis" name="Ward"> <field type="n" name="ward_no" description="ward" wildcard="2"> <definition type="option" connectiontype="db" minlength="1" startleft="1" sort="asc" dependfld="gid"> <dsn encoding="UTF-8">pgsql://postgres:postgres@localhost:5432/template_postgis_20</dsn> <sql>SELECT DISTINCT ward_no FROM public.tbl_ward1 WHERE ward_no IS NOT NULL ORDER BY ward_no</sql> </definition> </field> </layer> </searchitem> -------------------------------------------------------------------------------------------------- in ms_error.txt file i saw this log [Sun Mar 03 17:02:18 2013].56000 getSymbol(): Symbol definition error. Parsing error near (gid):(line 525) [Sun Mar 03 17:02:18 2013].56000 msDrawMap(): rendering using outputformat named png8 (AGG/PNG8). and also i found in chrome console invalid JSON SyntaxError get stack: function () { [native code] } arguments: null caller: null length: 0 name: "" prototype: Object __proto__: function Empty() {} <function scope> message: "Unexpected token }" set stack: function () { [native code] } arguments: null caller: null length: 1 name: "" prototype: Object __proto__: function Empty() {} <function scope> __proto__: Error constructor: function SyntaxError() { [native code] } name: "SyntaxError" stack: undefined __proto__: d thanx a lot again.. suman -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-tp2790207p4025079.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users