OGR join problem

yoda (sent by Nabble.com) lists at NABBLE.COM
Fri Feb 24 01:34:00 PST 2006


I try to join a shp file and a mysql table.
I try this :

ogrinfo -ro
/var/www/html/cartoweb3/projects/lyon/server_conf/lyon/data/sa_lo.shp -sql
"select * from sa_lo a left join 'MYSQL:
lyon,user=root,port=3306'.lones b on a.Id=b.id"

and retrieve that :

INFO: Open of
`/var/www/html/cartoweb3/projects/lyon/server_conf/lyon/data/sa_lo.shp'
using driver `ESRI Shapefile' successful.
ERROR 1: SQL: Unrecognised secondary field a.Id in JOIN clause..

the Id column (N,9,0) exist in the shape file and the id field (INT(6))
exist in the lones table.
Then i don't understand what's wrong.

An idea ?
--
View this message in context: http://www.nabble.com/OGR-join-problem-t1180147.html#a3105241
Sent from the Mapserver - User forum at Nabble.com.



More information about the MapServer-users mailing list