[Mapserver-users] Virtual Spatial Data and SQL query

[ludovic gnemmi]

Hi all,
I'm trying to set up a dynamic virtual spatial data
connection to map X,Y coordinates (from a Mysql odbc
connection) with OGR and phpmapscript.
It works with a simple sql query like:
<SrcSQL>SELECT * FROM table WHERE ...</SrcSQL>
but doesn't work with a more complicated query with
several tables and arithmetics operators (produce an
apache error).
I saw on the MapserverWiki:virtual spatial data
tutorial that the latest version of the OGR ODBC
driver passes the SQL directly to the ODBC driver. So
i don't undestand why my query doesn't work...ODBC
datasource is working properly, i've tested with
success this sort of query with a direct ODBC client
(Winsql-ODBC). Has anybody got an idea?
I'm working on windows with the last release of
mapserver-mapscript.
Thanks a lot.

Ludovic Gnemmi
DESS DCISS



	

	
		
Vous manquez d’espace pour stocker vos mails ? 
Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis. A télécharger gratuitement sur http://fr.messenger.yahoo.com