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

[Chris Hansen]

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
>