[Mapserver-users] Query

Mon Jul 7 10:15:42 EDT 2003

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C34492.40229CB0
Content-Type: text/plain

Hi:
Got to use filter on this layer you are trying to query on.
so map file will look something like,

LAYER 
 NAME layers
 TYPE ..
 STATUS ON
 DATA lakesshp

 FILTERITEM "value"
 FILTER ">100 and <200"
 LABELITEM "value"
 NAME "Lakes"
 COLOR ....
 TEMPLATE "....."
  END
END

More reference on Filter and filteritem in the mapfile reference in the
mapserver site.
Hth,
Gayathri

-----Original Message-----
From: Mohamed Elshayal Smart [mailto:elshayal at smartwebonline.com] 
Sent: Thursday, July 03, 2003 7:55 PM
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] Query

Dear Sirs,
I use the following and it works 

mode=itemnquery&qlayer=lakes&item=area&value=100

but I try to use the following  expression but it does not work.

mode=itemnquery&qlayer=lakes&item=area&value>100&value<200

and how can I write expression statement in map file

Thank you and best personal regards
Mohamed Elshayal

------_=_NextPart_001_01C34492.40229CB0
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=rtl><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY dir=ltr bgColor=#ffffff>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2>Hi:</FONT></SPAN></DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff size=2>Got to 
use filter on this layer you are trying to query on.</FONT></SPAN></DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff size=2>so map 
file will look something like,</FONT></SPAN></DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2>LAYER&nbsp;<BR>&nbsp;NAME&nbsp;layers<BR>&nbsp;TYPE&nbsp;..</FONT></SPAN></DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2>&nbsp;STATUS&nbsp;ON<BR>&nbsp;DATA lakesshp</FONT></SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2>&nbsp;FILTERITEM "value"<BR>&nbsp;FILTER "&gt;100 and 
&lt;200"<BR>&nbsp;LABELITEM "value"<BR>&nbsp;NAME 
"Lakes"<BR>&nbsp;COLOR&nbsp;....<BR>&nbsp;TEMPLATE "....."<BR>&nbsp; 
END<BR>END<BR></FONT></SPAN></DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff size=2>More 
reference on Filter and filteritem in the mapfile reference in the mapserver 
site.</DIV></FONT></SPAN>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2>Hth,</FONT></SPAN></DIV>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2>Gayathri</DIV></FONT></SPAN>
<DIV><SPAN class=311491915-07072003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV></DIV>
  <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT 
  face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Mohamed Elshayal 
  Smart [mailto:elshayal at smartwebonline.com] <BR><B>Sent:</B> Thursday, July 03, 
  2003 7:55 PM<BR><B>To:</B> 
  mapserver-users at lists.gis.umn.edu<BR><B>Subject:</B> [Mapserver-users] 
  Query<BR><BR></FONT></DIV>
  <DIV><FONT face=Arial size=2>Dear Sirs,</FONT></DIV>
  <DIV><FONT face=Arial size=2>I use the following and it works </FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial 
  size=2>mode=itemnquery&amp;qlayer=lakes&amp;item=area&amp;value=100</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>but I try to use the following&nbsp; 
  expression&nbsp;but it does not work.</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV>
  <DIV><FONT face=Arial 
  size=2>mode=itemnquery&amp;qlayer=lakes&amp;item=area&amp;value&gt;100&amp;value&lt;200</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>and how can I write expression statement in map 
  file</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Thank you and best personal regards</FONT></DIV>
  <DIV><FONT face=Arial size=2>Mohamed 
Elshayal</FONT></DIV></DIV></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C34492.40229CB0--