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

[Gjermund Gusland Thorsen]

&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
>