Please solve my problem,
I tested Kumars kaSearch.php from
http://lists.maptools.org/pipermail/ka-map-users/attachments/20070615/8d56b836/kaSearch.obj
but the search function still doesn't give me any results from PostGIS-Layers.
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.
I don't get any errors - so I have no idea what is going wrong.
my maplayer is like this....
LAYER
NAME "abcdef"
TYPE polygon
STATUS on
METADATA
"queryable" "true"
"searchfield" "name"
"fields" "name"
END
connectiontype POSTGIS
connection "dbname=xyz user=postgres11 password=123456 host=localhost port=5432"
DATA "the_geom from (select the_geom,name from temp where test='01') as myquery using unique the_geom using srid=-1"
labelitem "name"
TOLERANCE 1
TOLERANCEUNITS meters
CLASS
NAME "name"
TEMPLATE "ttt_query.html"
STYLE
COLOR 100 200 0
OUTLINECOLOR 0 0 0
END
LABEL
COLOR 0 0 0
SIZE SMALL
END
END
when i m using kasearch then it gives this error.....
Fatal error: [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
\ka-map-1.0\htdocs\tools\search\kaSearch.php on line
184plz someone tell me the solution of it..
thanks in advance
--
with Regards
Gaurav Rajput
=====-----=====-----=====
_______________________________________________
ka-Map-users mailing list
ka-Map-users@...
http://lists.maptools.org/mailman/listinfo/ka-map-users
