[Mapserver-users] Problems with QUERY on SPATIALORACLE
Gregorio Greco
g.greco at cineca.it
Fri Mar 19 10:14:41 EST 2004
This is a multi-part message in MIME format.
------=_NextPart_000_0048_01C40DCD.488A3390
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
=20
Hi All,
I have a problem with SpatialOracle and I want to do simple query for =
the moment like this:I starting work with Mapserver and =
SpatialOracle:now I am successful to display the map and to navigate, =
therefore for this aspect I do not have problems...I have problems with =
'query' o 'nquery' on data fetched from the spatialoracle tables.I have =
read that others have my same problem and I have read in a mail (21 - =
Jan - 2004) that you are working in this function.... I would want to =
know kindly when this function will be available or if it exists =
another way for to do this.... I'm sorry for my little english and I =
thanks in advance who me will be able to help in this problem !I take a =
small portion of code of the map file:........ others settings =
.................._______________________________________________________=
______________________________________________________________________LAY=
ER # States polygon layer begins here NAME province =
CONNECTIONTYPE oraclespatial CONNECTION "greco/9meno5=3D4 at test9i" =
DATA "GEOM FROM (SELECT P.PROVINCIA,P.CASI_TOT,P.GEOM FROM PROVINCE P)" =
STATUS DEFAULT TYPE POLYGON CLASSITEM CASI_TOT =
CLASS NAME '141767-197144' EXPRESSION ([CASI_TOT] >=3D 141767 =
and [CASI_TOT] <=3D 197144) TEMPLATE 'templates/query_province.htm' =
COLOR 87 170 134 OUTLINECOLOR 255 255 255 END #end =
class____________________________________________________________________=
___________________.......etc etc etc........ Best =
RegardsGregorio_________________________________________________________D=
r. Gregorio GrecoCINECA - InterUniversity Computing Center - SISS =
http://www.cineca.it Via Magnanelli, 6/3 40033 Casalecchio di Reno (BO) =
Italy E-mail: g.greco at cineca.it Phone:+39-051-6171938 =
_____________________________________________________
------=_NextPart_000_0048_01C40DCD.488A3390
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #000000; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<BLOCKQUOTE id=3D0><LABEL id=3DHbSession =
SessionId=3D"3264591565"></LABEL>
<DIV><!--StartFragment --> </DIV></BLOCKQUOTE>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Djustify><PRE><FONT face=3DArial =
color=3D#0000ff><STRONG>Hi All,
I have a problem with SpatialOracle and I want to do simple query for =
the moment like this:</STRONG></FONT></PRE><PRE><FONT face=3DArial =
color=3D#0000ff><STRONG>I starting work with Mapserver and =
SpatialOracle:</STRONG></FONT></PRE><PRE><FONT face=3DArial =
color=3D#0000ff><STRONG>now I <FONT color=3D#000000><FONT =
color=3D#0000ff> am successful to display </FONT></FONT> the map and to =
navigate, <!--StartFragment --></STRONG><FONT color=3D#000000> <FONT =
color=3D#0000ff><STRONG>therefore for this aspect <!--StartFragment =
--></STRONG><STRONG> I do not have =
problems...</STRONG></FONT></FONT></FONT></PRE></DIV>
<DIV align=3Djustify><PRE><STRONG><FONT face=3DArial color=3D#ff0000>I =
have problems with 'query' o 'nquery' on data fetched from the =
spatialoracle tables.</FONT></STRONG></PRE></DIV>
<DIV align=3Djustify><PRE><FONT color=3D#ff0000><STRONG><FONT =
face=3DArial><FONT color=3D#0000ff>I have read</FONT> =
</FONT></STRONG><FONT color=3D#0000ff><FONT face=3DArial><STRONG>that =
others have my same problem and I have read in a mail (21 - Jan - 2004) =
</STRONG></FONT></FONT></FONT><FONT color=3D#ff0000><FONT =
color=3D#0000ff><FONT face=3DArial><STRONG>that you <!--StartFragment =
--></STRONG><FONT color=3D#000000> </FONT></FONT></PRE></DIV>
<DIV align=3Djustify><PRE><FONT face=3DArial><STRONG>are working in =
this function....<!--StartFragment --></STRONG><STRONG> I would want to =
know <!--StartFragment --></STRONG> <STRONG>kindly</STRONG> =
<STRONG>when this function will be available or if it exists another =
</STRONG></FONT></PRE></DIV>
<DIV align=3Djustify><PRE><FONT face=3DArial><STRONG>way for to do =
this....</STRONG> </FONT></PRE></DIV>
<DIV align=3Djustify><PRE><FONT face=3DArial><STRONG>I'm sorry for my =
little english and <!--StartFragment --> I thanks in advance who me =
will be able to help</STRONG> <STRONG>in this problem =
!</STRONG></FONT></PRE></DIV>
<DIV align=3Djustify><PRE><STRONG><FONT face=3DArial>I take a small =
portion of code of the map file:</FONT></STRONG></PRE><PRE><STRONG><FONT =
face=3DArial>........ others settings =
..................</FONT></STRONG></PRE><PRE><STRONG><FONT =
face=3DArial>____________________________________________________________=
_________________________________________________________________</FONT><=
/STRONG></PRE><PRE><STRONG><FONT face=3DArial>LAYER # States polygon =
layer begins here<BR> <BR> =
NAME province<BR> CONNECTIONTYPE =
oraclespatial<BR> CONNECTION "<A =
href=3D"mailto:greco/9meno5=3D4 at test9i">greco/9meno5=3D4 at test9i</A>"<BR><=
/PRE></FONT></STRONG><PRE><STRONG><FONT face=3DArial> =
DATA "GEOM FROM (SELECT P.PROVINCIA,P.CASI_TOT,P.GEOM FROM PROVINCE =
P)"<BR></PRE></FONT></STRONG><STRONG><FONT=20
face=3DArial></FONT></STRONG><PRE><STRONG><FONT =
face=3DArial> =
STATUS DEFAULT<BR> =
TYPE =
POLYGON<BR> <BR></FONT></STRONG><STRONG><FONT =
face=3DArial> <BR>CLASSITEM =
CASI_TOT<BR></FONT></STRONG></PRE><PRE><STRONG><FONT =
face=3DArial> CLASS<BR> =
NAME '141767-197144'<BR> EXPRESSION =
([CASI_TOT] >=3D 141767 and [CASI_TOT] <=3D =
197144)<BR> TEMPLATE =
'templates/query_province.htm'<BR> COLOR =
87 170 134<BR> OUTLINECOLOR 255 255 =
255<BR> <BR> END #end =
class</PRE><PRE>_________________________________________________________=
______________________________</PRE><PRE>.......etc etc etc........ =
</FONT></STRONG></PRE><PRE><STRONG><FONT =
face=3DArial></FONT></STRONG> </PRE><PRE><STRONG><FONT =
face=3DArial></FONT></STRONG> </PRE><PRE><STRONG><FONT =
face=3DArial>Best Regards</FONT></STRONG></PRE></DIV>
<DIV align=3Djustify><PRE><STRONG><FONT =
face=3DArial>Gregorio</FONT></STRONG></PRE></DIV></BLOCKQUOTE>
<BLOCKQUOTE></FONT></FONT><PRE><FONT =
size=3D2></FONT> </PRE><PRE><FONT =
size=3D2>_________________________________________________________<BR>Dr.=
Gregorio Greco<BR>CINECA - InterUniversity Computing Center =
- SISS <BR><A =
href=3D"http://www.cineca.it">http://www.cineca.it</A> <BR>Via =
Magnanelli, 6/3 <BR>40033 Casalecchio di Reno (BO) Italy =
<BR>E-mail: <A =
href=3D"mailto:g.greco at cineca.it">g.greco at cineca.it</A> =
<BR>Phone:+39-051-6171938 =
<BR>_____________________________________________________</FONT></PRE></B=
LOCKQUOTE>
<P></P></BODY></HTML>
------=_NextPart_000_0048_01C40DCD.488A3390--
More information about the mapserver-users
mailing list