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

[Gjermund Gusland Thorsen]

What about a screendump?

ggt667

On 3/7/07, Chris Bisgard <cbisgard at racc.org> wrote:
> Dale,
>
> I didn't know it needed to be UTF-8, thanks! I changed it and will use
> that from now on.
>
> However, that didn't fix the problem. I'm still stumped.
>
> Chris
>
>
> > From: Dale Bengston <dbengston at preservationstudio.com>
> > Subject: Re: [FX.php List] Mysterious asterisks appearing in fields
> > To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> > Message-ID:
> >       <C14A9B43-CDD8-47B3-8D93-F0D4BEE07529 at preservationstudio.com>
> > Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
> >
> > Hi Chris,
> >
> > Are you by any chance specifying something besides UTF-8 for
> > the character set on your web page that contains the form?
> > For FMSA 7/8, it should be specified like this:
> > <meta http-equiv="content-type" content="text/html; charset=UTF-8">
> >
> > Hope this helps,
> > Dale
> >
> > On Mar 5, 2007, at 8:24 PM, Chris Bisgard wrote:
> >
> > > Hi all,
> > >
> > > I've been using FX.php and FileMaker 7/8 for the past two years for
> > > simple "search and display results" websites, and I'm now
> > building my
> > > very first solution that will allow data entry via the web. It's a
> > > very straightforward "survey" type database, where a guest
> > fills out a
> > > one-page form of questions and hits submit, entering the
> > data into a
> > > new record in FileMaker. No logins/passwords, sessions or anything
> > > fancy here.
> > >
> > > I've got it working so that I can enter data, but anything I enter
> > > gets asterisks prepended and appended to it. So, for example, if I
> > > were to enter "Bob Smith" (no quotes) in my form field,
> > when it gets
> > > into the database, the field contains "*Bob Smith*" (again,
> > no quotes,
> > > but the asterisks are there). This looks almost like some kind of
> > > intended behavior by FileMaker, like it's trying to tell me
> > that the
> > > data was entered in an unexpected way.
> > >
> > > I'm afraid I'm missing something obvious here. Does anyone
> > know what
> > > this is?
> > >
> > > I'll paste the code below, though I think it's pretty
> > straightforward.
> > > I'm only including two fields for now in order to keep this
> > simple.
> > > Note
> > > that I'm using 'trim()' to clean up the POST data, but this is not
> > > what's causing the problem. It happens without 'trim()' as well.
> > >
> > > <!-- Here's the HTML form: -->
> > >
> > > <form id="clp" name="clp" method="post"
> > action="submit.php"> Name of
> > > Organization: <input name="OrgName" type="text" id="OrgName"
> > > size="20" maxlength="255" /><br>
> > > Name of Contact: <input name="OrgContact" type="text"
> > id="OrgContact"
> > > size="20" maxlength="255" /><br>
> > > <input type="submit" name="Submit" value="Submit" /> </form>
> > >
> > >
> > > <!-- And here's the PHP script: -->
> > >
> > > <?php
> > >
> > > include_once("/inetpub/wwwroot/FX/FX.php");
> > > include_once("/inetpub/wwwroot/FX/server_data.php");
> > > include_once("/inetpub/wwwroot/FX/FMErrors.php");
> > >
> > > $OrgName=trim($_POST['OrgName'],"*");
> > > $OrgContact=trim($_POST['OrgContact'],"*");
> > >
> > > $query=new FX($serverIP,$webCompanionPort);
> > > $query->setDBData('CLP','Web');
> > > $query->AddDBParam('OrgName',$OrgName);
> > > $query->AddDBParam('OrgContact',$OrgContact);
> > >
> > > $addRecord=$query->FMNew();
> > >
> > > ?>
> > >
> > > <!-- END -->
> > >
> > > Thanks for any help.
> > >
> > > Chris Bisgard
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>