<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Hi <FONT face="Times New Roman"
size=3>Prema,</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Did you tried to add field name in the
URL?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><A
href="http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/zap/htdocs/CountryOrcl.map&mode=itemnquery&layer=world_poly&qlayer=world_poly&qitem=cntry_name&qstring='india'"><STRONG>http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/zap/htdocs/CountryOrcl.map&mode=itemnquery&layer=world_poly&qlayer=world_poly&qitem=cntry_name&qstring='<FONT
color=#ff0000>CNTRY_NAME</FONT>=india</STRONG><FONT face=Arial
size=2>'</A></FONT><BR></DIV>
<DIV><FONT face=Arial size=2>I also think you should add this field name into
your layer definition:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>DATA "shape,cntry_name FROM world USING SRID 8307"</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Francesco</FONT></DIV></FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=lists@NABBLE.COM href="mailto:lists@NABBLE.COM">Prema Selvam (sent by
Nabble.com)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=MAPSERVER-USERS@LISTS.UMN.EDU
href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, January 18, 2006 4:56
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [UMN_MAPSERVER-USERS] Problem in
Oracle Spatial with MapServer in ItemnQuery</DIV>
<DIV><BR></DIV>Hi All, <BR><BR> Thanks all for the solution of my
previous query ( Problem in Oracle Spatial Connection - Empty Image).
<BR><BR> Now I got new query, Please give me some solution.
<BR><BR> I am able to establish connection between MapServer and Oracle
Spatial 10g, and we can get the Map Image prefectly ( refer Subject <I>Problem
in Oracle Spatial Connection - Empty Image</I>) <BR><BR> I am unable to
get the any <B>Query </B> Function in MapServer with Oracle Spatial , but
i can able to do the query operation with Shapefiles. <BR><BR> The
Mapfile, quey and Error is give below, <BR><BR><B>Mapfile</B> <BR><BR>
MAP <BR>
DEBUG ON <BR>
NAME World_Country <BR>
EXTENT -180 -90
180 83.60415649414 <BR>
SIZE 800 400 <BR>
SHAPEPATH
'/ms4w/apps/zap/data/' <BR>
IMAGETYPE GIF <BR>
STATUS ON
<BR><BR> WEB <BR>
TEMPLATE 'templates/ZapTemp.html' <BR>
IMAGEPATH
'/ms4w/tmp/ms_tmp/' <BR>
IMAGEURL '/ms_tmp/'
<BR> END <BR><BR>
PROJECTION <BR>
"proj=latlong" <BR>
"ellps=WGS84" <BR>
END <BR><BR>
QUERYMAP <BR>
STATUS ON <BR>
STYLE HILITE
<BR>
COLOR 255 255 0 <BR>
END <BR><BR>
LAYER <BR>
DEBUG ON <BR><BR>
PROJECTION <BR>
"proj=latlong" <BR>
"ellps=WGS84" <BR>
END <BR><BR>
CONNECTIONTYPE
oraclespatial <BR>
CONNECTION "world/land@orcl" <BR>
DATA
"shape FROM world USING SRID 8307" <BR><BR>
NAME
world_poly <BR>
STATUS ON <BR>
TYPE
POLYGON <BR><BR><BR>
DUMP TRUE
<BR><BR>
TEMPLATE "templates/ZapTemp.html" <BR><BR>
TOLERANCE 5
<BR><BR>
CLASS <BR>
NAME
'The_World' <BR>
STYLE <BR>
COLOR 0 200 0 <BR>
END <BR>
END <BR>
END <BR> END <BR><BR><BR><B>Query</B> <BR><BR><B><A
href="http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/zap/htdocs/CountryOrcl.map&mode=itemnquery&layer=world_poly&qlayer=world_poly&qitem=cntry_name&qstring=india"
target=_top
rel=nofollow>http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/zap/htdocs/CountryOrcl.map&mode=itemnquery&layer=world_poly&qlayer=world_poly&qitem=cntry_name&qstring=india</A></B>
<BR><BR><BR><B>Error Message</B> <BR><BR>msOracleSpatialLayerWhichShapes():
OracleSpatial error. Error: ORA-00920: invalid relational operator . Query
statement: SELECT rownum, cntry_name, shape FROM world WHERE india AND
SDO_FILTER( shape, MDSYS.SDO_GEOMETRY(2003, 8307,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180,-90,180,83.6041565)
),'querytype=window') = 'TRUE' . Check your data statement. <BR><BR><B>Spatial
data in Oracle</B> <BR><BR>SQL> describe world <BR><BR> Name
Null? Type
<BR> ----------------------------------------- --------
---------------------------- <BR><BR> SHAPEID
NOT NULL NUMBER(38) <BR> FIPS_CNTRY
VARCHAR2(2) <BR> GMI_CNTRY
VARCHAR2(3) <BR> ISO_2DIGIT
VARCHAR2(2) <BR> ISO_3DIGIT
VARCHAR2(3)
<BR> CNTRY_NAME
VARCHAR2(254) <BR> LONG_NAME
VARCHAR2(40) <BR> SOVEREIGN
VARCHAR2(40)
<BR> POP_CNTRY
NUMBER <BR> CURR_TYPE
VARCHAR2(16) <BR> CURR_CODE
VARCHAR2(4)
<BR> LANDLOCKED
VARCHAR2(1) <BR> SQKM
NUMBER <BR> SQMI
NUMBER
<BR> COLORMAP
NUMBER <BR> SHAPE
MDSYS.SDO_GEOMETRY
<BR><BR><BR> Please give me a some solution <BR><BR> Waiting for the
reply <BR><BR>Thanks & Regards, <BR>Prema Selvam <BR>GISbiz <BR><BR><BR>
<HR align=left width=300>
View this message in context: <A
href="http://www.nabble.com/Problem-in-Oracle-Spatial-with-MapServer-in-ItemnQuery-t945593.html#a2449588">Problem
in Oracle Spatial with MapServer in ItemnQuery</A><BR>Sent from the <A
href="http://www.nabble.com/Mapserver---User-f1215.html">Mapserver - User</A>
forum at Nabble.com. </BLOCKQUOTE></BODY></HTML>