[mapguide-users] display SQL select result
Kenneth Skovhede, GEOGRAF A/S
ks at geograf.dk
Tue Feb 3 05:42:52 EST 2009
The most generic solution would be to create a temporary SDF FeatureSource,
and then insert the features from the database, one by one.
Code for this can be found in the buffer.aspx/jsp/php file (except the
read from db loop).
However, it may be easier and faster to create a regular layer,
displaying the entire source
table (or view). Instead of executing the select to the database, simply
set the "Filter" of the
layer to match the "WHERE" clause in the SQL.
Obviosly, this is not always possible.
Another option would be to create a temporary table, which is supported
database systems, and use that as a FeatureSource.
Some databases can return an SHP file with the data. Such a file could
be used to
create an SHP FeatureSource, and display it right away.
Regards, Kenneth Skovhede, GEOGRAF A/S
Peter Filip skrev:
> My sql select is returning spatial data. I'm looking for a neat solution for
> display this data. I can't put this data to a DB table. So i need somehow
> copy this data somewhere in the mapguide reposiroty. :-) There will be
> couple thousands of records.
> Any suggestions ?
More information about the mapguide-users