[FX.php List] Spaces in field names

[Bob Patin]

Jonathan,

It won't hurt anything, but when you're using URLs, it might... I  
haven't used them in URLs. When I do a site where I generate any URLs  
with field names in it, I go into the DB and change the field names if  
I have to.

I've done a bunch of sites for clients where they did their own  
database, and rather than go in and change everything in some cases, I  
just used what they had. I'm doing one now with tons of fields, and he  
doesn't want me to change his field names, so I just went with what he  
had.

The one thing I did have him do though, was to change any incidence of  
an ampersand in a field value, so that I could pass those values in  
URLs without it messing things up.

 From the land of the 6-0 TN Titans!

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

On Oct 22, 2008, at 10:44 AM, Jonathan Schwartz wrote:

> 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
> -- 
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list