Strange Query Error

[Pagurek,Debbie [NCR]]

Tim,
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
 
<FID>yourUniqueIdColumn</FID> 
 
in order to indicate what the primary key or unique field is.
I'm curious to know if this works, so please reply to me and the list!
 
Debbie Pagurek
  -----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Pascoe,Tim [Burlington]
Sent: Wednesday, February 15, 2006 9:12 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] Strange Query Error



	Sorry for the cross-post, but I'm unsure of where this problem may be occurring. I have a mapserver installation running in IIS, on a Windows2000 machine. A little while ago, I upgraded all the components to:

	PHP 5.0.5.5

	Mapserver 4.6

	Mapscript 4.6.1

	Chameleon 2.0

	GDAL 1.3

	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. This all worked perfectly before the upgrade. Everything seems to work fine now, 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 returned for the virtual layer, unfiltered, every time; no matter what point is selected.

	I know of one other person experiencing exactly this behavior, and that installation has the latest versions of all software, with the same problem. Anyone have any ideas?

	Any help is appreciated,

	

	Timothy Pascoe


	Environment Canada / Environnement Canada
	Canada Centre for Inland Waters / Centre Canadien des Eaux Intérieures
	867 Lakeshore Road / 867, chemin Lakeshore
	Burlington, Ontario / Burlington (Ontario)

	L7R 4A6
	
	Tel/Tél: (905) 336-6239
	Fax/Téléc: (905) 336-4699
	E-mail/C. élec: tim.pascoe at ec.gc.ca <mailto:tim.pascoe at ec.gc.ca> 
	Government of Canada/Gouvernement du Canada

	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.

	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060227/aa9a0cff/attachment.html