Sure, I'll find a solution, now it is easier :-))

I can even set the RESULT_FIELDS to the "real" field name, with trailing spaces 
and then avodi trimming in initgroups.php ($sf = (substr(trim($sf0), 0, 1) == 
'&' ? _p(trim($sf0)) : trim($sf0));)

This works but it can possibly be a problem with some other data...

Thanks very much

regards, dejan 

> -----Original Message-----
> From: Alessandro Pasotti [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, April 11, 2007 12:30 PM
> To: [email protected]
> Cc: Gambin Dejan
> Subject: Re: [pmapper-users] Empty field values in query result
> 
> Il 12:06, mercoledì 11 aprile 2007, Gambin Dejan ha scritto:
> > Thanks Alessandro,
> >
> > I found the problem after opening the dbf file with the hex 
> editor. I 
> > found that field names have trailing spaces, so for example field 
> > named ID is shown as ID but in fact it is "ID" followed by 
> 8 spaces. I 
> > didn't see this before. Now I have to find a way to 
> workaround this if possible...
> 
> Yes, I've seen this before, it's probably a conversion error 
> while exporting into SHP from other GIS tools.
> 
> Some perl one liner or opening with OpenOffice and trim the 
> field names should do the trick.
> 
> 
> -- 
> Alessandro Pasotti
> itOpen - "Open Solutions for the Net Age"
> w3:  www.itopen.it
> Linux User# 167502
> 

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to