Hi all Mapserver 5.6 WFS generated from WKT in SQL Server 2000 database. Connecting with: CONNECTIONTYPE OGR CONNECTION "ODBC:username/p...@dsnname,viewname(geometryfieldname)" PROCESSING "CLOSE_CONNECTION=DEFER"
All works fine for WMS, but for WFS requests I see the same SQL executed at the server for every record, along these lines Select * from viewname WHERE XMAX > 545000.00000000 AND XMIN < 550786.00000000 AND YMAX > 260040.00000000 AND YMIN < 270000.00000000 which works OK for small areas, but is tragic for larger ones. >From posts on these lists I realised MapServer cannot work out which is the PK, so I added this setting CONFIG "ODBC_OGR_FID" "UID" But IF my "UID" field is text, then it breaks my WFS completely. In the SQL trace I see this: Select * from viewname WHERE UID = 0 (which gives an error, and the WFS returns no records. I don't know where it makes up the 0 from, as that is not in my UID field - perhaps an arbitrary rowID assigned by MS?). Now if I make sure my table has an integer unique field, and refer to this in the CONFIG setting, it all works fine, but this is rather inconvenient in my scenario. I'm thinking this is a new bug in 5.6, because we used this setting in 4.10 to make GetFeatureInfo work and it liked text fields then. NB this setting with a text field also breaks GetFeatureInfo - I get an exception. Any tips on how to make this work with text field greatly appreciated, or perhaps confirmation that this is a bug? thanks Crispin -- View this message in context: http://n2.nabble.com/WFS-from-database-WKT-CONFIG-ODBC-OGR-FID-problem-with-text-field-tp4702079p4702079.html Sent from the Mapserver - User mailing list archive at Nabble.com. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
