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
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
