[FX.php List] Mysterious asterisks appearing in fields

[Gjermund Gusland Thorsen]

I love to see screenshots in such cases :-)

ggt667

On 3/6/07, Dale Bengston <dbengston at preservationstudio.com> wrote:
>
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070306/41e7f989/attachment.html