Well I got it all to work in the end. Just looked more closely at some PostGIS examples, and realised I needed to do a little more in the data section something like - DATA "SitePoint1 from (select * from Site) as DataUSING UNIQUE SiteID USING SRID=4326" Have managed to get SQL strings with ISO characters - umlauts etc to now display correctly in labels - at last (OGR VRT route was being stubborn). Had to use MapServer 6, PMapper 4.2 and a newer MSSQL2008 plugin to get the PMapper query side to work (not sure which aspect was being kooky mind), guess I had to start the upgrade process at some point!! Now just need to get that spatial index sorted....
Chris On 4 September 2012 10:16, Chris Jackson <webturt...@gmail.com> wrote: > So the errors in PMapper are - Validation of search.xml file FAILED: > > Warning: DOMDocument::schemaValidate(): Element 'searchlist': Missing > child element(s). Expected is ( searchitem ). in > D:\ms4w\apps\pmapper\habitats\incphp\query\search.php on line 69 > > I am guessing this is caused by not enough data coming back - In my layer > I have: > DATA "SitePoint1 from Site USING UNIQUE SiteID USING SRID=4326" > ...... > METADATA > "DESCRIPTION" "Managed Realignment Sites1" > "RESULT_FIELDS" "[SiteID],[SiteName]" > "RESULT_HEADERS" "Site ID,Name" > > I am thinking that my data section isn't pulling back any queryable fields. > I did try DATA "SitePoint1 from (select * from Site) USING UNIQUE SiteID > USING SRID=4326" but that just gave me a black screen - errors weren't > forthcoming. > Anyone got this type of layer (using msplugin_mssql2008.dll plugin) to > work? > > Thanks > Chris > > > > > On 4 September 2012 06:32, Chris Jackson <webturt...@gmail.com> wrote: > >> Hi Armin >> It was a sort of a feeler question - you might of said querying not >> configured for that plugin , use ogr virtual driver instead (which works, >> bar an annoying character issue between sql and the driver - not PMapper >> related) >> Cheers >> Chris >> On 3 Sep 2012 23:35, "Armin Burger" <armin.bur...@gmail.com> wrote: >> >>> On 03/09/2012 23:20, Chris Jackson wrote: >>> > Hi all >>> > >>> > I just wondered if msplugin_mssql2008.dll derived layers can be >>> queried and >>> > labelled in PMapper? I can get the points to display, but not able to >>> > retrieve attributes (when I click the select by shape the layer list >>> on top >>> > right is empty). >>> > >>> > Thanks >>> > Chris >>> >>> I would guess that it should work, at least select and identify (what do >>> you get for the latter...?) though I don't know exactly what >>> "msplugin_mssql2008.dll derived layers" are. And without the usual >>> debugging info (see wiki FAQ) it will not be possible to provide you >>> much help. >>> >>> armin >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Live Security Virtual Conference >>> Exclusive live event will cover all the ways today's security and >>> threat landscape has changed and how IT managers can respond. Discussions >>> will include endpoint security, mobile security and the latest in malware >>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >>> _______________________________________________ >>> pmapper-users mailing list >>> pmapper-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/pmapper-users >>> >> > ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
