<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=213282920-27022006><FONT face=Arial color=#0000ff
size=2>Tim,</FONT></SPAN></DIV>
<DIV><SPAN class=213282920-27022006><FONT face=Arial color=#0000ff size=2>I
haven't tested this, but I think I might have an answer for you. I found an old
post that indicated that the OVF file that points to a Microsoft Access database
should contain</FONT></SPAN></DIV>
<DIV><FONT face=Arial></FONT><SPAN class=213282920-27022006> </DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><FID><SPAN
class=213282920-27022006>yourUnique</SPAN>IdColumn</FID></FONT>
</FONT></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=213282920-27022006><FONT face=Arial color=#0000ff size=2>in
order to indicate what the primary key or unique field is.</FONT></SPAN></DIV>
<DIV><SPAN class=213282920-27022006><FONT face=Arial color=#0000ff size=2>I'm
curious to know if this works, so please reply to me and the
list!</FONT></SPAN></DIV>
<DIV><SPAN class=213282920-27022006></SPAN> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=213282920-27022006>Deb</SPAN>b<SPAN class=213282920-27022006>ie
Pagurek</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV></DIV>
<DIV><FONT face=Tahoma><FONT size=2><FONT face=Arial><FONT
color=#0000ff> <SPAN
class=213282920-27022006> </SPAN></FONT></FONT>-----Original
Message-----<BR><B>From:</B> UMN MapServer Users List
[mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf Of </B>Pascoe,Tim
[Burlington]<BR><B>Sent:</B> Wednesday, February 15, 2006 9:12 AM<BR><B>To:</B>
MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> [UMN_MAPSERVER-USERS] Strange
Query Error<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"><!-- Converted from text/rtf format -->
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Sorry for the
cross-post, but I</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial size=2>’</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>m unsure of where this problem may
be</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> <FONT face=Arial
size=2>occurring</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial size=2>. I have a mapserver installation running in IIS, on a
Windows2000 machine. A little while ago, I upgraded all the components
t</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>o</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial size=2>:</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>PHP
5.</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>0.5.5</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Mapserver
4.6</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Mapscript
4.6.1</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Chameleon
2.0</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>GDAL
1.3</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>I am using OGR to
create a virtual layer of points, and then filter this layer using an SLD
generated on the fly, based on user input.</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us> <FONT face=Arial size=2>This all worked
perfectly before the upgrade.</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us> <FONT face=Arial size=2>Everything seems to work
fine</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2> now</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial size=2>, the layers filter properly, and display the way they
should. However, if a point is queried, the data returned in the Chameleon
query window is for the first record in the recordset</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us> <FONT face=Arial size=2>returned for the
virtual layer, unfiltered</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>, every time; no matter what point is
selected.</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>I know of one other
person experiencing exactly this</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us> <FONT face=Arial size=2>behavior</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>,</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> <FONT
face=Arial size=2>and that</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us> <FONT face=Arial size=2>installation</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial size=2> has the latest
versions of all software, with the same problem.</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us> <FONT face=Arial size=2>Anyone have any
ideas?</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Any help
is</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> <FONT face=Arial
size=2>appreciated</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial size=2>,</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us></SPAN><A name=""><SPAN
lang=en-us></SPAN></A></P>
<P align=left><SPAN lang=en-us><FONT face="Comic Sans MS"
color=#000080>Timothy Pascoe</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN></P><BR>
<P align=left><SPAN lang=en-us><FONT face=Verdana color=#800080
size=2>Environment Canada / Environnement Canada<BR>Canada Centre for Inland
Waters / Centre Canadien des Eaux Intérieures<BR>867 Lakeshore Road / 867,
chemin Lakeshore<BR>Burlington, Ontario / Burlington
(Ontario)</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Verdana color=#800080 size=2>L7R
4A6<BR><BR></FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face="Trebuchet MS" color=#008000 size=2>Tel/Tél: (905)
336-6239<BR>Fax/</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face="Trebuchet MS" color=#008000
size=2>Téléc</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face="Trebuchet MS" color=#008000
size=2>: (905) 336-4699<BR>E-mail/C. élec:</FONT></SPAN><SPAN lang=en-us>
</SPAN><A href="mailto:tim.pascoe@ec.gc.ca"><SPAN lang=en-us></SPAN><SPAN
lang=en-us><U></U></SPAN><U><SPAN lang=en-us><FONT face="Trebuchet MS"
color=#0000ff size=2>tim.pascoe@ec.gc.ca</FONT></SPAN></U><SPAN
lang=en-us></SPAN></A><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Tahoma color=#000080 size=2>Government of
Canada/Gouvernement du Canada</FONT></SPAN></P>
<P align=left><I><SPAN lang=en-us><FONT face="Comic Sans MS" color=#808080
size=1>This e-mail represents the opinions and views solely held by its author
and in no manner may be considered as representing those of his/her
employer.</FONT></SPAN></I><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us></SPAN></P></BLOCKQUOTE></BODY></HTML>