[FX.php List] Spaces in Field Names...one more time with gusto

[Gjermund Gusland Thorsen]

What works? + is good? or %20 is good?

%20%20%20%20%20 can be in sequence, while +++++ sometimes turns out as
just 1 space...

2008/12/9 Jonathan Schwartz <jschwartz at exit445.com>:
> OK.
>
> 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.
>
> J
>
> 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
>>
>> ggt
>>
>> 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
>>>  underline)
>>>  FMP FIND URL:           Alpha+Beta (FX (?) replaces space with "+" in
>>> URL)
>>>  FMP SORT FIELD URL:     Alpha%20Beta  (FX (?) replaces space with "%20"
>>> in
>>>  URL)
>>>
>>>  Here's an actual URL that shows the existence of both methods in the
>>> same
>>>  URL:
>>>
>>>
>>>
>>> http://Admin:Admin@000.000.000.000:80/fmi/xml/FMPXMLRESULT.xml?-db=DB.fp7&-lay=web&-max=50&-sortfield.1=Alpha%20Beta&-sortorder.1=ascend&Alpha+Beta=John+Smith&-find
>>>
>>>  So...
>>>  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"
>>>
>>>
>>>  Argh.
>>>
>>>
>>>  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?
>>>
>>>  J
>>>
>>>
>>>
>>>  --
>>>  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
>
>
> --
> 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
>