[FX.php List] Spaces in field names

[Thomas Neumann]

Hi,

I'm working with a db where a lot of fieldnames contain spaces. Have you 
tried to use urlEncode on the fieldname?

Tomy

Jonathan Schwartz schrieb:
> Hi Folks,
>
> What are the options if a db has spaces in filed names?
>
> When I create the db, I always omit them. But, I'm about to start a 
> project with an existing db that does contain spaces in field names.
>
> Using Debug, I note that the query properly translates spaces to the 
> "%20" character.  However, the sort part of the query seems to 
> translate the space to an underline...breaking the query. (This might 
> be a function of how I wrote the query code. I'm not sure).
>
> It *is* possible for me to rid the field names of spaces.  I was 
> wondering what other options exist.
>
> Thx.
>
> jonathan

-- 
Dipl.- Ing (FH) Thomas Neumann
Carl-Maria-von-Weber-Str. 26
D-95448 Bayreuth
Germany
Steuernummer 208/254/80340

SATlive http://www.take-sat.de
SATlive Forum: Http://www.board-4you.de/v18/boards/35