<br><font size=2 face="sans-serif">Are you using the MSSQL spatial extension?
Or you only need to create points from a X and Y fields.<br>
If you don't have the spatial extension you must use the Virtual Spatial
Data</font>
<br><font size=2 face="sans-serif">http://www.mapserver.org/input/vector/VirtualSpatialData.html</font>
<br>
<br><font size=2 face="sans-serif">You can specify a sql query in the config
file</font>
<br><font size=2 face="sans-serif">Steve</font>
<br>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Marcus" <the_incredibal@gmx.de>@lists.osgeo.org</b>
</font>
<br><font size=1 face="sans-serif">Envoyé par : mapserver-users-bounces@lists.osgeo.org</font>
<p><font size=1 face="sans-serif">2010-12-10 05:35</font>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">A</font></div>
<td><font size=1 face="sans-serif"><mapserver-users@lists.osgeo.org></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td><font size=1 face="sans-serif">[mapserver-users] Mapserver query using
database connection</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br>
<br>
<br><font size=2 face="Arial">Hello,</font>
<br><font size=2 face="Arial">I am a cartography student from Germany und
I am working on my diploma thesis at the moment. My task is to plan and
create a webservice application for a transportation company and I decided
to use the UMN Mapserver for the implementation. The users should have
the ability to query the objects, too. As you probably know the query function
of Mapserver allows to query the attribute table or to join another table-file,
but now there’s my question: Is it possible to create a query which directly
connects to an existing database via PHP and show the results in a query
template? I have doubts that this could work, cause the query function
uses mapserver variables which are converted into the strings or numbers
like they are in the attribute table by the Mapserver program and in my
opinion a database won’t understand these variables. But may be you’ve
heard of a possibility and I would be glad if anyone could help me. Please
keep in my mind that I have to use a Microsoft SQL Server 2008 database
and sqlserv as the “driver”.</font>
<br><font size=2 face="Arial">Thank you and best regards from Germany.</font>
<br><font size=2 face="Arial">Marcus</font>
<br><font size=2 face="Arial"> </font><tt><font size=2>_______________________________________________<br>
mapserver-users mailing list<br>
mapserver-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
</font></tt>
<br>
<br>
<br>