[FX.php List] Spaces in Field Names...one more time with gusto
Gjermund Gusland Thorsen
ggt667 at gmail.com
Tue Dec 9 12:51:30 MST 2008
I am asking a question about this:
http://user:pass@server:port/fmi/xml/FMPXMLRESULT.xml?-db=DB.fp7&-lay=web&-max=50&-sortfield.1=Alpha%20Beta&-sortorder.1=ascend&Alpha+Beta=John+Smith&-find
Does this parameter: Alpha+Beta=John+Smith
or this parameter work: -sortfield.1=Alpha%20Beta
There is no urlencode() or str_replace().
ggt
2008/12/9 Jonathan Schwartz <jschwartz at exit445.com>:
> 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
> _______________________________________________
> 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