[FX.php List] Spaces in Field Names...one more time with gusto
Jonathan Schwartz
jschwartz at exit445.com
Tue Dec 9 12:23:32 MST 2008
I'll answer your question when you answer my question. ;-)
What do I test and where? I don't whether you are referring to
urlencode or str_replace, and where in the script to use the
functions.
J
At 8:04 PM +0100 12/9/08, Gjermund Gusland Thorsen wrote:
>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
>>
>_______________________________________________
>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
More information about the FX.php_List
mailing list