<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV>Hi Parwaiz,</DIV><BR><DIV><BLOCKQUOTE type="cite"> <DIV> </DIV> <DIV> How search system in ka-map works with PostGIS? I tried but failed to get <BR>any result. With shapefile it is working fine.<BR></DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Only shapefile part has been properly developed. The PG connection should be adjusted.</DIV><DIV>At the moment I've never needed a search system to PG passing from Mapserver. But it could be useful.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>on </DIV><DIV>tools/search/kaSearch.php</DIV><DIV>there's no implementation to catch the PostgreSQL connection.</DIV><DIV>On old code of Paul (xsearch,php) you can find:</DIV><DIV>-------------------------------------------------------------------</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">if($oLayer->connectiontype == MS_POSTGIS){</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; min-height: 15px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;"> </SPAN></FONT><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">$searchstring = $szSearchfield . ' ~* \'' . $searchstring .'\'</SPAN></FONT><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;"> </SPAN></FONT><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">';</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; min-height: 15px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">} else {</SPAN></FONT><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;"> </SPAN></FONT><FONT class="Apple-style-span" face="Monaco" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">// Shapefile</SPAN></FONT></DIV><DIV>...</DIV><DIV>}</DIV><DIV>-------------------------------------------------------------------</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>If you have time to test and debug your contribution will be appreciated.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>thanks</DIV><DIV>Lorenzo</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR><BLOCKQUOTE type="cite"><DIV> </DIV> <DIV><BR class="khtml-block-placeholder"></DIV> <DIV>can anybody send advice or help me on this subject</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>parwaiz<BR></DIV><DIV> <BR class="khtml-block-placeholder"></DIV><HR size="1">Do you Yahoo!?<BR> Get on board. <A href="http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo.com/mailbeta">You're invited</A> to try the new Yahoo! Mail.<DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">ka-Map-users mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:ka-Map-users@lists.maptools.org">ka-Map-users@lists.maptools.org</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://lists.maptools.org/mailman/listinfo/ka-map-users">http://lists.maptools.org/mailman/listinfo/ka-map-users</A></DIV> </BLOCKQUOTE></DIV><BR></BODY></HTML>