[FX.php List] Re: Mysterious asterisks appearing in fields

[Chris Bisgard]

Solved!!!

It turned out to be that I had a default operator of 'cn' in FX.php.
Changing that value to 0 fixed it. Whew!

Dan and Derrick, thank you for pointing me in the right direction. And
thanks to everyone for the very educational help on this, especially
to Gjermund who was willing to look at my files. (Derrick, yes, sorry,
you were correct... the asterisks weren't appearing in the XML url.)

So, I think I set that default operator way back when I first set up
FX, because I was afraid my queries would all use "starts with" and
cause problems with a search feature I was trying to get working. I
later learned how to do this using the AddParam function with
$op='cn', but I never bothered changing it back in FX.php.

I would never have foreseen this problem as a result of leaving that
default. You guys rock.

Oy... time for a beer.

Chris

On 3/15/07, Derrick Fogle <derrick at fogles.net> wrote:
> According to an earlier post, the asterisks do NOT appear in the XML
> URL:
>
> On Mar 9, 2007, at 12:42 PM, Chris Bisgard wrote:
>
> >                     [OrgName] => Array
> >                         (
> >                             [0] => *RACC*
> >                         )
> >
> >                     [OrgContact] => Array
> >                         (
> >                             [0] => *Chris Bisgard*
> >                         )
> >
> >     [URL] =>
> > http://192.168.0.7:80/fmi/xml/FMPXMLRESULT.xml?-db=CLPtest&-
> > lay=Web&-max
> > =50&OrgName.op=cn&OrgName=RACC&OrgContact.op=cn&OrgContact=Chris
> > +Bisgard
> > &-new
>
> ...which brings us back to the ".op=cn" statements in the URL. Why do
> those need to be in a "-new" statement? I'm definitely leaning
> towards the idea that FMP is putting those asterisks into the field
> data because of the .op=cn statements. When creating new records, you
> shouldn't need those parts. Can we re-visit the whole FX.php script?
> There shouldn't be any op attributes passed.
>
>
> On Mar 15, 2007, at 1:52 PM, Chris Bisgard wrote:
>
> > This is sounding like a BIG clue... the asterisks don't appear in the
> > POST data or in the query array, but they show up in the array
> > returned by FMNew() and in the Filemaker XML url (and in the FMP file,
> > obviously). Are there other places along the way to check the
> > variables?
>
>
> Derrick Fogle
> derrick at fogles.net
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>