OGR Connection to MySQL
Christian Braun
christian.braun at TUDOR.LU
Wed May 9 07:52:10 PDT 2007
Hey List,
I want to establish a connection between mapserver (pmapper client) and a
MySQL-DB.
It works fine with smaller queries like "select id,x,y from table". Actually
i don't have a problem with such little things.
If the queries getting more complex I get the results only in the Terminal
window with ogrinfo.
Such a query is
"SELECT ALL
MG.MC_Name_col AS MCName,
M1.`AttribValueNum_col` AS x,
M2.`AttribValueNum_col` AS y
FROM MeasCampGlobal_tbl MG, MeasCampAttrib_tbl M1
LEFT OUTER JOIN IdRefStr_tbl I1
ON M1.AttribType_id=I1.id,
MeasCampAttrib_tbl M2
LEFT OUTER JOIN IdRefStr_tbl I2
ON M2.AttribType_id=I2.id
WHERE M1.MeasCampGlobal_tbl_id=MG.idMeasCampGlobal_tbl
AND M2.MeasCampGlobal_tbl_id=MG.idMeasCampGlobal_tbl
AND MC_WWTPRef_col = 'Bleesbrück'
AND I1.RefStr_col = 'Att_WWTP_CoordX'
AND I2.RefStr_col = 'Att_WWTP_CoordY'"
As I said only results are displayed in the Terminal with the ogrinfo tool.
Mapserver hangs up.
Any Ideas???
System is Ubuntu Edgy, Mapserver 4.10, GDAL 1.4
Thanks in advance,
Christian
More information about the MapServer-users
mailing list