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