Tuesday, March 18, 2008

Map file export from qgis

In QGis (a desktop GIS client supporting esri-shape, postgis, wms...) you can export a project as a umn mapserver mapfile. When i tried that out yesterday, QGis 9.1 threw an error: map export error:ms_export phyton module not found. I tried replacing ms_export.py by a new one, but that didn't work out. Today i installed QGis 9.2 rc1. In QGis 9.2 ms_export is converted to a real plugin (amongst many other improvements). Also debugging is better, it still threw the same error, but the message was more descriptive! It appeared i forgot to select a project file, in the export-window. Export was succesful! http://guinea.genuchten.net
Blogged with the Flock Browser

Monday, March 17, 2008

CF/Oracle 8; expected NUMBER got DATE

Today i found this error in ColdFusion 7/Oracle 8

Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected NUMBER got DATE

It appeared to be the fact that oracle 8 misunderstands <cfqueryparam cfsqltype="cf_sql_bigint"> as a date.