[FX.php List] Spaces in Field Names...one more time with gusto
Gjermund Gusland Thorsen
ggt667 at gmail.com
Tue Dec 9 12:04:59 MST 2008
Please answer the question: What works?
is "+" or "%20" good?
ggt
2008/12/9 Jonathan Schwartz <jschwartz at exit445.com>:
> Sorry to be dense, but where exactly in the code is urlencode or str_replace
> used?
>
> J
>
> At 7:40 PM +0100 12/9/08, Gjermund Gusland Thorsen wrote:
>>
>> 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
>>>
>> _______________________________________________
>> 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
>
More information about the FX.php_List
mailing list