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