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

[Gjermund Gusland Thorsen]

How on earth did you get that in there?

On 3/15/07, Chris Bisgard <bisgard at gmail.com> wrote:
> 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
> >
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>