[FX.php List] Spaces in field names

[Dale Bengston]

Jonathan,

I'm with Bob - it shouldn't hurt anything since FX encodes the  
parameters before it passes them as a query. If spaces were a problem,  
I think we would have all flushed it out by now, since a lot of our  
data values no doubt have spaces, and they're in the query too.

Dale%20Bengston

[no comment about the status of Wisconsin football teams, college or  
pro]

On Oct 22, 2008, at 11:37 AM, Bob Patin wrote:

> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list