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

[Chris Bisgard]

Okay, some new information...

1. I've triple-checked, and it definitely doesn't make a difference
whether or not I use "trim()" on the variables.

2. I have started from scratch with a new FileMaker database. For
testing purposes, it's a very simple setup that allows Guest access via
XML to modify records in all tables/all layouts, and there are only two
fields -- OrgName and OrgContact. And still I get the asterisks. 

3. Curiously, when I use Gjermund's version of the FX query, as
follows...

   $q=new FX( $serverIP, $webCompanionPort ); 
   $q->setDBData( 'CLPtest', 'web' ); 
   $q->AddDBParam( 'OrgName', $_POST['OrgName'] ); 
   $q->AddDBParam( 'OrgContact', $_POST['OrgContact'] ); 
   $r=$q->FMNew();

...the asterisks still turn up in FileMaker, and they still appear in
the $r array, but now they do NOT appear in the FileMaker URL, encoded
or otherwise.

4. For the page encoding, I have used Dreamweaver's "page properties"
dialogue to set UTF-8. I assumed that was sufficient?

5. To Gjermund: I am no longer adding the pipes, as I felt they had
served their purpose and were only adding clutter. Sorry for the
confusion. I can put them back if needed.

6. I am running FMSA version 8v3. I just realized I should be on 8v4,
and I'm going to apply the update after 5pm PST today to see if that
helps, but I am doubtful. 

Yikes, I'm getting a little nervous. I was really hoping the asterisk
thing would be a "known issue," but considering nobody here seems to
have seen it before, I'm worried there's something really obscure and
screwy somewhere in my setup. 

I really do appreciate everyone's attempts to help, thanks.

Chris Bisgard


> For the sake of experimentation, how about without the trim function?
> 
> $query->AddDBParam('OrgName', $_POST['OrgName']); 
> $query->AddDBParam('OrgContact', $_POST['OrgContact']);
> 
> Dale
> 
> On Mar 7, 2007, at 3:26 PM, Chris Bisgard wrote:
> 
> > Gjermund Gusland Thorsen wrote:
> >
> >> Are all pages referring to UTF-8 by now?
> >
> > Yep. There's only two pages (input form and target script) and both 
> > are on UTF-8 now.
> >
> >> I would really like to see your script from receival of 
> _POST array 
> >> to FMNew
> >
> > Okay, here you go (note I've since removed the step that 
> was enclosing 
> > the pipe characters for testing):
> >
> > <!-- BEGIN -->
> >
> > $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 -->
> >
> > Joel Shapiro wrote:
> >
> >> Hi Chris
> >>
> >> Any chance you have any kind of auto-enter going on in your FM 
> >> fields?
> >>
> >> -Joel
> >
> > Joel, good though, but nothing like that. These are just 
> simple text 
> > fields.
> >
> > -Chris Bisgard
> > _______________________________________________
> > FX.php_List mailing list
> > FX.php_List at mail.iviking.org
> > http://www.iviking.org/mailman/listinfo/fx.php_list