Spatial Query on VirtualSpatial layer

[Blaine Hackett]

Frank, or anyone else

I got the spatial query to return data to the query
template but only after doing an "nquery".  By doing
this,it is also querying an actual shapefile that it
is and returning the data from the shapefile along
with the VRT layer data.

The error again, "mapserv(): Web application error. No
way to generate a valid map extent from selected
shapes." would seem to indicate that there is no way
to get a map extent from the VRT layer.

The query template has correct data from the tables
but the map that is displayed is completely wacked
out!

I am projection XY coords in LAT/LONG on the fly to
UTM.  Could that be part of the problem?

I could send screen shots of the original map and then
the query map if that would help.

Anything else I can try?

Thanks
Blaine


--- Frank Warmerdam <warmerdam at pobox.com> wrote:

> Blaine Hackett wrote:
> > I am using an X and Y field from an ODBC
> connection to
> > show the VSD layer.  I can see them but I have not
> > successfully queried them.  I have tried several
> > different query types within the VSD.
> ...
> > So, to click on them or draw a box around several
> > points and have the info about the point returned
> to
> > an html query template is all I am tying to do.
> >
> > Does that make sense?
>
> Blaine,
>
> As far as I can tell your approach is reasonable,
> but then I didn't see
> query template.  I don't actually use queries very
> often but as far as I know
> they should work the same for VRT/ODBC layers as
> they do for other OGR layers.
>
> You may need to be careful about uppercase/lower
> case for attribute names.
> Verify the attributes returned by ogrinfo.exe
> against your .vrt file against
> the names for the attributes in your query template.
>
> Sorry I don't have more constructive suggestions.
>
> Best regards,
> --
>
---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank
> Warmerdam, warmerdam at pobox.com
> light and sound - activate the windows |
> http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial
> Programmer for Rent
>
>




__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail