[ka-Map-users] Problem with Search in KAMAP with Postgis layers

[Gaurav Thakur]

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 *184*




plz someone tell me the solution of it..


thanks in advance








-- 
with Regards

Gaurav Rajput
=====-----=====-----=====
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ka-map-users/attachments/20090923/40f644ea/attachment.htm