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

[Jonathan Schwartz]

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