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

Dale Bengston dbengston at tds.net
Tue Dec 9 14:59:20 MST 2008


Encoding of query elements is done by FX.php without interaction from  
us. Reference the sub-functions CreateCurrentSort() and  
CreateCurrentSearch() in the FX.php script file.

Dale


On Dec 9, 2008, at 1:51 PM, Gjermund Gusland Thorsen wrote:

> 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
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 1582 bytes
Desc: not available
Url : http://mail.iviking.org/pipermail/fx.php_list/attachments/20081209/66f2a24c/smime-0001.bin


More information about the FX.php_List mailing list