ovf query error

[Pagurek,Debbie [NCR]]

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.
 
Anyone else have any suggestions??
 
D. Pagurek

  _____  

From: william paul [mailto:williampaul28 at yahoo.com] 
Sent: Tuesday, November 07, 2006 5:28 PM
To: Pagurek,Debbie [NCR]; mapserver mapserver
Subject: Re: [UMN_MAPSERVER-USERS] ovf query error


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.

Any ideas? or whe I can setup <FID>mycolumnid</FID>?

William

"Pagurek,Debbie [NCR]" <Debbie.Pagurek at EC.GC.CA> wrote: 

	in your mapfile, make sure you have DUMP TRUE (you can put this
somewhere in your layer)
	 
	Hope that works,
	D. Pagurek

  _____  

	From: UMN MapServer Users List
[mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of william paul
	Sent: Tuesday, November 07, 2006 2:34 PM
	To: MAPSERVER-USERS at LISTS.UMN.EDU
	Subject: [UMN_MAPSERVER-USERS] ovf query error
	
	
	Hi:
	
	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
	
	In the ovf file I have:
	....
	<FID>UID</FID>
	....
	In Map file:
	class
	    template.html
	end
	header header_template.html
	footer footer_template.html
	
	in template I have:
	
	<tr>.....<td>[UID]</td>
	
	The table in the SQL Server I have 3 columns:
	
	UID type uniqueidentifier
	x_coord type float
	y_coord type float
	
	I don't see where I do wrong
	
	Thank you in advance
	
	William
	
  _____  

	Sponsored Link 
	
	Talk more and pay less. Vonage can save you up to $300 a year on
your phone bill. Sign up now.
<http://clk.atdmt.com/VON/go/yhxxxvon1080000017von/direct/01/> 


  _____  

Sponsored Link

Free Uniden 5.8GHz Phone System with Packet8 Internet Phone Service
<http://www.getpacket8.net/yahoo2> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061108/1303277b/attachment.html