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

[Gjermund Gusland Thorsen]

How do you store the content of you field BTW?
Are there any Furigana settings?

Those two above should not be a problem as the asterisks are already
in there at time on -fmnew executions, however it came to my mind. As
a related problem, probably not in this case.

ggt667

On 3/7/07, Chris Hansen <chris at iviking.org> wrote:
> Chris,
>
> Thanks, that helped.  It appears that the asterisks are showing up on
> the FileMaker side (though to double check you could set "DEBUG" to
> true and check the URL...)  So, that brings us to the next steps:
>
> 1) What version of FileMaker are you using?
>
> 2) Is there any change if you perform a POST versus a GET request
> (you can either test this via the FX query, or by pasting the URL for
> a query into your browser...)
>
> 3) In recent testing I've found that FMSA 8 runs a database's
> shutdown script each time a query is performed via the web.  I'm
> waiting to hear back from FMI whether this is expected behavior, but
> I doubt it.  If you're running the latest version of FileMaker, does
> your database have a shutdown script that could be doing this?
>
> 4) Try creating a new database and perform a basic query there.  Do
> the asterisks still show up?
>
> Best,
>
> --Chris Hansen
>    FileMaker 8 Certified Developer
>    FileMaker 7 Certified Developer
>    Creator of FX.php
>    "The best way from FileMaker to the Web."
>    www.iViking.org
>
>
> On Mar 7, 2007, at 12:32 PM, Chris Bisgard wrote:
>
> > As suggested by Gjermund, here's a screenshot:
> > http://www.racc.org/resources/fmweb/screen0307.gif
> >
> > It shows the submit results in the browser on the left, and the
> > results
> > in FileMaker on the right. (Note the pipe characters are expected, per
> > Chris's suggestion below.)
> >
> > Chris Hansen wrote:
> >
> >> Chris,
> >>
> >> Have you tried echoing out the data from the form on which
> >> you post the data to FileMaker?  Do you know where the error
> >> is introduced (i.e. does PHP think the asterisks are there,
> >> too)?  I'd be interested to know what PHP actually thinks is
> >> in that variable at various places along the way.  Sometimes,
> >> when I'm doing highly targeted output of these sorts of
> >> things I also like to enclose the data being output in pipe
> >> characters or something.  Basically, some way to ensure that
> >> I'm also aware of any leading or trailing invisible characters.
> >
> > Hi Chris, thanks. My script does echo the user input from the form,
> > both
> > the raw POST data and then the variables I'm generating from them. I
> > hadn't thought to enclose the data with pipes to see if there's some
> > invisible weirdness there -- good idea. When I did it, it showed that
> > the asterisks are getting placed outside the pipes, which I think
> > means
> > that the error is occurring in this part of the script:
> >
> >   $query->AddDBParam('OrgName',$OrgName);
> >   $query->AddDBParam('OrgContact',$OrgContact);
> >   $addRecord=$query->FMNew();
> >
> > I also did a print_r of the $addRecord array and found that the
> > asterisks appear in that array. And here they are, encoded as '%
> > 7C', in
> > the FileMaker URL (shortened for ease of reading):
> >
> > FMPXMLRESULT.xml?-db=CLP&-lay=Web&-max=50&OrgName.op=cn&OrgName=%
> > 7CRACC%
> > 7C&OrgContact.op=cn&OrgContact=%7CChris%7C&-new
> >
> > So, this means FX is adding the asterisks? Or am I confused (highly
> > likely)?
> >
> > Thanks again,
> > Chris Bisgard
> > _______________________________________________
> > 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
>