Please solve my problem,<br><br><pre><font size="4"><i>I tested Kumars kaSearch.php from <br></i><i> <a href="http://lists.maptools.org/pipermail/ka-map-users/attachments/20070615/8d56b836/kaSearch.obj" target="_blank">http://lists.maptools.org/pipermail/ka-map-users/attachments/20070615/8d56b836/kaSearch.obj</a><br>
</i><i><br></i></font><font size="4"><i>but the search function still doesn't give me any results from PostGIS-Layers.</i><br><i>My PostGIS-layer is drawn correctly and also query-function works - only kaSearch doesn't work. If I replace the PostGIS-data with a shapefile (with same data) the (original,unpatched) kaSearch works.<br>
</i><i><br></i></font><i><font size="4">I don't get any errors - so I have no idea what is going wrong.</font><br></i></pre>my maplayer is like this....<br><br><br><br>LAYER<br> NAME "abcdef"<br> TYPE polygon<br>
STATUS on<br> METADATA<br> "queryable" "true" <br> "searchfield" "name"<br> "fields" "name"<br> END<br> connectiontype POSTGIS<br> connection "dbname=xyz user=postgres11 password=123456 host=localhost port=5432"<br>
DATA "the_geom from (select the_geom,name from temp where test='01') as myquery using unique the_geom using srid=-1"<br> labelitem "name"<br> TOLERANCE 1<br> TOLERANCEUNITS meters<br> CLASS<br>
NAME "name"<br> TEMPLATE "ttt_query.html"<br> STYLE<br> COLOR 100 200 0<br> OUTLINECOLOR 0 0 0<br> END<br> LABEL<br> COLOR 0 0 0<br> SIZE SMALL<br> END<br> END<br clear="all">
<br>when i m using kasearch then it gives this error.....<br><br><b>Fatal error</b>: [MapServer Error]: msPOSTGISLayerGetShape(): Error
executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor2
BINARY CURSOR FOR SELECT
"name"::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from
(select the_geom,name from temp where test='01') as myquery
WHERE the_geom = 2147483647
-ERROR: operator does not exist: geometry = integer
LINE 1: ...om where test='01') as myquery WHERE the_geom =
21474836... ^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
More Help: in <b>\ka-map-1.0\htdocs\tools\search\kaSearch.php</b> on line <b>184</b><br><br><br><br><br>plz someone tell me the solution of it..<br><br><br>thanks in advance<br> <br><br><br><br><br><br><br><br>-- <br>with Regards<br>
<br>Gaurav Rajput<br>=====-----=====-----=====<br><br>