<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=596322614-08112006><FONT face=Arial
color=#0000ff size=2>Hmm - interesting. The symptom that you discuss here -
the fact that without the FID specified you only get the first record -
indicated that you need to specify a FID in your OVF file. What version on SQL
Server are you using? And, is your FID column defined in SQL server as the
primary key on the table? By the way - I use SQL Server 2000 and I do not have
to specify FID in my OVF to get my queries working.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=596322614-08112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=596322614-08112006><FONT face=Arial
color=#0000ff size=2>Anyone else have any suggestions??</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=596322614-08112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=596322614-08112006><FONT face=Arial
color=#0000ff size=2>D. Pagurek</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> william paul
[mailto:williampaul28@yahoo.com] <BR><B>Sent:</B> Tuesday, November 07, 2006
5:28 PM<BR><B>To:</B> Pagurek,Debbie [NCR]; mapserver
mapserver<BR><B>Subject:</B> Re: [UMN_MAPSERVER-USERS] ovf query
error<BR></FONT><BR></DIV>
<DIV></DIV>Thank you, but it didn't solved the problem. I have created in the
SQL Server a column called FID. With this column and removing the
<FID>...</FID> line from the ovf file I can make query, but when I
click on different point I get the same result: the first tupple from Sql Server
table. For each point I query I get only the records for the first
point.<BR><BR>Any ideas? or whe I can setup
<FID>mycolumnid</FID>?<BR><BR>William<BR><BR><B><I>"Pagurek,Debbie
[NCR]" <Debbie.Pagurek@EC.GC.CA></I></B> wrote:
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR>
<DIV dir=ltr align=left><SPAN class=725440822-07112006><FONT face=Arial
color=#0000ff size=2>in your mapfile, make sure you have DUMP TRUE (you can
put this somewhere in your layer)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=725440822-07112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=725440822-07112006><FONT face=Arial
color=#0000ff size=2>Hope that works,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=725440822-07112006><FONT face=Arial
color=#0000ff size=2>D. Pagurek</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> UMN MapServer Users List
[mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf Of </B>william
paul<BR><B>Sent:</B> Tuesday, November 07, 2006 2:34 PM<BR><B>To:</B>
MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> [UMN_MAPSERVER-USERS] ovf
query error<BR></FONT><BR></DIV>
<DIV></DIV>Hi:<BR><BR>I have created a OVF file to generate point files from
MS SqlServer and it's working OK. I can see the point but When I try to query
I get: msQueryByPoint() Search returned no results. No matching record(s)
found<BR><BR>In the ovf file I
have:<BR>....<BR><FID>UID</FID><BR>....<BR>In Map
file:<BR>class<BR> template.html<BR>end<BR>header
header_template.html<BR>footer footer_template.html<BR><BR>in template I
have:<BR><BR><tr>.....<td>[UID]</td><BR><BR>The table in the
SQL Server I have 3 columns:<BR><BR>UID type uniqueidentifier<BR>x_coord type
float<BR>y_coord type float<BR><BR>I don't see where I do wrong<BR><BR>Thank
you in advance<BR><BR>William<BR>
<DIV></DIV>
<HR SIZE=1>
Sponsored Link <BR><BR>Talk more and pay less. Vonage can save you up to $300
a year on your phone bill. <A
href="http://clk.atdmt.com/VON/go/yhxxxvon1080000017von/direct/01/">Sign up
now.</A></BLOCKQUOTE><BR>
<P>
<HR SIZE=1>
Sponsored Link<BR><BR><A href="http://www.getpacket8.net/yahoo2">Free Uniden
5.8GHz Phone System with Packet8 Internet Phone Service</A></BODY></HTML>