[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