[Mapserver-users] itemquery - wrong number of results

Mon Oct 13 07:36:31 PDT 2003

<html><base href=3D"https://freemail.web.de/"/><style>p {margin: 0px}</style=
><body style=3D'font-size:9pt; font-family:Verdana; font-family: Verdana' ><=
P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-=
ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">Hi,<=3Fxml:n=
amespace prefix =3D o ns =3D "urn:schemas-microsoft-com:office:office" /><o:p>=
</o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0=
pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT f=
ace=3D"Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P><P class=3DM=
soNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-lang=
uage: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"> <o:p></o:p></=
FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPA=
N lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Tim=
es New Roman">The Shape File which I use has 241 rows (in ArcView). I use =
Mapserver3.6 on Win2000.<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNo=
rmal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language=
: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">I do a itemquery and se=
t the FILTER like "Filter ("[Number]" =3D~ /^%item1%/)".<o:p></o:p></FONT></=
FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3D=
EN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New =
Roman">The column "Number" is string-type.<o:p></o:p></FONT></FONT></SPAN>=
</P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D=
"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"></FON=
T></FONT></SPAN> </P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><=
SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT face=3D"Times New Rom=
an" size=3D3>"Item1" is set via URL.</FONT></SPAN></P><P class=3DMsoNormal sty=
le=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"=
><FONT face=3D"Times New Roman" size=3D3></FONT></SPAN> </P><P class=3DMsoN=
ormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-languag=
e: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">If "item1" is empty, I=
 get 217 rows but it should be 241=3F<o:p></o:p></FONT></FONT></SPAN></P><P =
class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-an=
si-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">If "item1" i=
s "106" I get "no results", although this string is in the table.<o:p></o:=
p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt">=
<SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D=
"Times New Roman">If "item1" is "105" I get the data for this object =96 but=
 I can not see any differences between "106" and "105". <o:p></o:p></FONT>=
</FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lan=
g=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times Ne=
w Roman"> <o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal styl=
e=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB">=
<FONT size=3D3><FONT face=3D"Times New Roman">I created an new column in ArcVi=
ew and copied all entries, using the option "asString".<o:p></o:p></FONT><=
/FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=
=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New=
 Roman">No difference.<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNorm=
al style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: =
EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"> <o:p></o:p></FONT><=
/FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=
=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New=
 Roman">But if I set a class like this:<o:p></o:p></FONT></FONT></SPAN></P=
><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"ms=
o-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">classite=
m NUMBER<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARG=
IN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT s=
ize=3D3><FONT face=3D"Times New Roman"><SPAN style=3D"mso-spacerun: yes">  =
</SPAN>class<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"=
MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FO=
NT size=3D3><FONT face=3D"Times New Roman"><SPAN style=3D"mso-spacerun: yes">&nb=
sp; </SPAN><SPAN style=3D"mso-tab-count: 1">     &n=
bsp;    </SPAN><SPAN style=3D"mso-spacerun: yes"> </SPAN=
>Expression "106"<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal st=
yle=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB=
"><FONT size=3D3><FONT face=3D"Times New Roman"><SPAN style=3D"mso-spacerun: yes=
">  </SPAN><SPAN style=3D"mso-tab-count: 1">    &nb=
sp;     </SPAN><SPAN style=3D"mso-spacerun: yes"> <=
/SPAN>COLOR 255 0 0<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal =
style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-=
GB"><FONT size=3D3><FONT face=3D"Times New Roman"><SPAN style=3D"mso-spacerun: y=
es">     </SPAN>OUTLINECOLOR 0 0 0 <o:p></o:p></FONT><=
/FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=
=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New=
 Roman"><SPAN style=3D"mso-spacerun: yes">   </SPAN>End<o:p></o:p>=
</FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><S=
PAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"T=
imes New Roman"> <o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNorm=
al style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: =
EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">the object is shown in th=
e map.<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN=
: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT siz=
e=3D3><FONT face=3D"Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P=
><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"ms=
o-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"> <o=
:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0c=
m 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FON=
T face=3D"Times New Roman">If I use Mapserv 4 on Win2000 I get the same prob=
lem. Maybe the Shape-File has an error=3F=3F=3F<o:p></o:p></FONT></FONT></SPAN><=
/P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"=
mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">What c=
an I do=3F <o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MAR=
GIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT =
size=3D3><FONT face=3D"Times New Roman"> <o:p></o:p></FONT></FONT></SPAN>=
</P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D=
"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman">&nbsp=
;<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm=
 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><=
FONT face=3D"Times New Roman">(If I try the same, using Mapserv4 and Linux (=
and Apache 1.3), I get an apache-error : "Premature end of script headers"=
 =96 what is wrong with my qstring :<o:p></o:p></FONT></FONT></SPAN></P><P c=
lass=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ans=
i-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"> <o:p></=
o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt=
"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT fac=
e=3D"Times New Roman">var qstring =3D ("\"[NUMBER]\" IN \"105\"");<o:p></o:p><=
/FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SP=
AN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Ti=
mes New Roman"> <o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNorma=
l style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: E=
N-GB"><FONT size=3D3><FONT face=3D"Times New Roman">)<o:p></o:p></FONT></FONT>=
</SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB=
 style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman=
"> <o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARG=
IN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT s=
ize=3D3><FONT face=3D"Times New Roman"> <o:p></o:p></FONT></FONT></SPAN><=
/P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"=
mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"> =
<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm =
0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><F=
ONT face=3D"Times New Roman"> <o:p></o:p></FONT></FONT></SPAN></P><P cl=
ass=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi=
-language: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"> Thank yo=
u,</FONT></FONT></SPAN></P><P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt">=
<SPAN lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"><FONT size=3D3><FONT face=3D=
"Times New Roman">robert<o:p></o:p></FONT></FONT></SPAN></P><P class=3DMsoNo=
rmal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DEN-GB style=3D"mso-ansi-language=
: EN-GB"><FONT size=3D3><FONT face=3D"Times New Roman"> <o:p></o:p></FONT=
></FONT></SPAN></P><P><A href=3D"mailto:mapserver-users at lists.gis.umn.edu"><=
/A> </P></body></html>
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F<br>Horoskop, Comics, VIPs, Wetter, Sport und Lotto im WEB.DE Screensa=
ver1.2<br>Kostenlos downloaden: <A HREF=3D"http://screensaver.web.de/=3Fmc=3D021=
110"><B>http://screensaver.web.de/=3Fmc=3D021110</B></A>