[FX.php List] Spaces in Field Names...one more time with gusto
jschwartz at exit445.com
Tue Dec 9 10:53:05 MST 2008
Now how do I fix my problem?
The previous suggestions were to use str_replace, but there are a
variety of places to do this, and I'm running out of combinations.
In the form?
In the fx.php AddDBParam?
Plus...what characters am I replacing with what?
For reference, the application here is my super duper search page
engine that serves multiple db's and web sites simultaneously. I
need to get this right so that it works for everyone because I can no
longer skirt the issue by requiring fieldnames with no spaces.
I'm not giving up until I crack this thing.
At 6:40 PM +0100 12/9/08, Gjermund Gusland Thorsen wrote:
>&20 is ascii value of the space character
>+ is urlencoding of the space character
>2008/12/9 Jonathan Schwartz <jschwartz at exit445.com>:
>> Hi Folks,
>> I still haven't 100% licked the spaces-in-field-names issue yet. Now I
>> realize why, and I'm just looking for a sanity check.
>> It appears that spaces in file names produces different behavior depending
>> whether the FMP query is a FIND parameter versus a SORT parameter.
>> It boils down to this:
>> FMP Field Definition: Alpha Beta
>> Alpha Beta Field Value: John Smith
>> Browser POST: Alpha_Beta (Apache Server replaces space with
>> FMP FIND URL: Alpha+Beta (FX (?) replaces space with "+" in URL)
>> FMP SORT FIELD URL: Alpha%20Beta (FX (?) replaces space with "%20" in
>> Here's an actual URL that shows the existence of both methods in the same
>> The html form displays the field name with the space.
>> Apache POST replaces the space with an underline.
>> FX/PHP replaces the space in a FIELD NAMEwith a "+"
>> FX/PHP replaces the space in a SORT NAMEwith a "%20"
>> If this is correct, then a single remedy won't work. A different remedy has
>> to be applied to SEARCH fields versus SORT fields.
>> I did get suggestions last time I posted this problem, but each time I
>> applied the remedy, it broke the other half. Now I see why.
>> Before I move forward....any comments?
>> Jonathan Schwartz
>> Exit 445 Group
>> jonathan at exit445.com
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
Exit 445 Group
jonathan at exit445.com
More information about the FX.php_List