Hi list, I am Using P.mapper 4.0 with MS4w version 3.0-beta11and kindly asking for help. The problem that i have is when i use the &zoomlayer=&zoomQuery= url key on the local polygon shape file it works as it should. But when i try to use the URL key on the oracle layer i get the error in MS_ERROR.txt. (OracleSpatial error. Error: ORA-00933: SQL command not properly ended) and noticed that the Queryfield "G_PID=" gets duplicated in the query statement ( Query statement: SELECT AREA, G_PID, MID,ID, DR, ST, GEOM FROM S_GRK_ID WHERE G_PID = G_PID = '1500523' AND SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE' . Check your data statement. ) .Otherwise oracle layer works and shows normally on map and works perfectly .If i set the FILTER/fFILTERITEM on ORAlayer in the .map file it works too. The DATA line from map file ( DATA "GEOM from GRK_ID USING UNIQUE FID SRID 2170" )
Kind regards Jose ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
