cgi mapserver query

[Greg Luker]

Hi,

Pagurek,Debbie [NCR] said:
> You can add <FID>your_index_column_name</FID>
> to your OVF definifition.

With the help of Debbie's previous suggestions, I've almost got this problem
fixed. I can now query a point and display its attributes from a MySQL
table, and all of it's other attributes from JOINed tables.

Adding the <FID> line that Debbie suggests above actually breaks the query
(maybe I've got the syntax wrong).

However, my fix only works using NQUERY (cgi mapsever), and so each returned
row contains data from the main record repeated for every instance of the
joined data. I want to show the main table data once and then n lines of
joined data (like on a customer
invoice where you see the customer details once, and all the invoice line
items below).

Any help or pointers to where I might find help would be greatly appeciated!

Thanks,
Greg Luker.