Hi, I'm using (yet) pmapper 4.2 and I'm having difficulty creating a postgis search. Despite being using pmapper 4.2, I've done this update http://svn.pmapper.net/trac/changeset/1272 and I have other searches working properly.
The search that does not work is this one: <searchitem name="n_rede_viaria" description="Rede Viaria"> <layer type="postgis" name="geopnh"> <field type="s" name="arteria" description="Nome da Arteria" wildcard="0"> <definition type="suggest" connectiontype="db" minlength="1" startleft="0" sort="asc"> <dsn encoding="UTF-8">pgsql://xxxxxx:xxxxxxxxxx@localhost/cartografia_oficial</dsn> <sql>SELECT DISTINCT arteria FROM rede_viaria.geopnh WHERE arteria ~* '[search]' ORDER BY arteria</sql> </definition> </field> </layer> </searchitem> With this, the suggestions appears as I write the name, but when I click on one of the suggestions I get (on firebug) an Internal Server Error - pm_cjs.js (linha 38) POST http://localhost/incphp/xajax/x_info.php 500 Internal Server Error 6ms and on Send (Post): &findlist=0&arteria=R NORTON DE MATOS&=Consultar&searchitem=n_rede_viaria&mode=search May it be a result of the content of "arteria" field be in uppercase? How can I get around this? Thank you very much! Best regards, Pedro ------------------------------------------------------------------------------ LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
