Dear Suman, I just had a quick view of you code and I think you should make the name "lower case"; and refer to this hint: ":HINT: No function matches the given name and argument types. You might need to add explicit type casts."
Please have a look at: http://svn.pmapper.net/trac/wiki/DocManualsearch Cheers, Serge On Sun, Mar 3, 2013 at 5:17 PM, Suman <ant_...@yahoo.com> wrote: > Hi all Pmapper User > I am using ms4w v3.0.6. , mapserver v6.0.3, PHP v5.4.3. and pmapper 4.2.0. > When I run a query on a PostGIS table I can see suggestions but when i > click > them no any response. > This is my inline search.xml > > -------------------------------------------------------------------------------------------------- > <searchlist version="1.0"> > <dataroot>$</dataroot> > > <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/gisdb</dsn> > <sql>SELECT DISTINCT name > FROM public.tbl_utility WHERE name ~* '^[search]' ORDER BY name</sql> > </definition> > </field> > </layer> > </searchitem> > </searchlist> > > --------------------------------------------------------------------------------------------------- > > and i found in chrome console invalid JSON > > Invalid JSON: <br /> > Warning: pg_query(): Query failed: ERROR: function xmin(box3d) does not > exist > LINE 2: xmin(box3d(geom)), > ^ > HINT: No function matches the given name and argument types. You might > need > to add explicit type casts. in > C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php on line 712<br /> > <br /> > Warning: pg_numrows() expects parameter 1 to be resource, boolean given in > C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php on line 716<br /> > {"mode":"search", "queryResult":0} > pm_cjs.js:38 > > > http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-td2790207.html#a4025076 > < > http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-td2790207.html#a4025076 > > > i tried all above given suggestions but i cant solve this problem.. plz > help > me.. > > suman > > > > -- > View this message in context: > http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/search-xml-with-postgis-invalidJSON-in-pmapper-v4-2-0-tp4025077.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 > -- Serge ------------------------------------------------------------------------------ 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
