[FX.php List] Anyone know how to escape characters?

[Chris Hansen]

Dave,

It is possible that this is an issue with FileMaker 5.  Every single 
release of FileMaker since the inception of XML support has fixed bugs 
in this area (often without a specific mention...)  It you have access 
to a machine running FM5.5 or FM6, I'd suggest testing your code there. 
  I do remember some problems a long while back, but I don't remember if 
the issue was FM5 specific.  If you are able to test elsewhere, let me 
know what you find.  Best,

--Chris Hansen
   creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On May 17, 2005, at 8:52 PM, Dave Strickler wrote:

> Interesting about FM7 and 1MB input files. Perhaps I am missing 
> something simple with FM 5.0...
>  
> I am definitely doing the $request->FMPostQuery= TRUE ; before I 
> called the DMAdd() function, so I'm pretty sure that's working. I 
> don't know how to double check it though.
>  
> As for the POST method, I am running the code from batch, and 
> therefore there is not 'human' form to deal with. I am extracting the 
> text string from Postgres, and then trying to write it to the FM 
> database, so fx.php translates the text string into part of the URL 
> and passes this to FM.
>  
> Perhaps this is a limitation in FM5? I have tried a string like "hello 
> hello hello..." up for 100 hellos, and it bombs, so I am pretty sure 
> this is not happening due to strange quotes or other characters that 
> should be escaped.
>  
> Dave Strickler
> MailWise LLC
> 617 267-0044 x810
> www.mailwise.com
>
>
> >>> glane at moyergroup.com 5/17/2005 6:11:26 PM >>>
> Dave,
>
> Is the data being input from a web form? If so, make sure you are 
> using POST for the form method and also use $request->FMPostQuery
> (true) in your PHP script.
>
> I don't have access to 5.0 right now but with FMSA7, I've 
> successfully put a megabyte of text into a field in FileMaker through 
> FX.php. There may also be browser restrictions coming into play. For 
> instance, Safari seems to limit text in input fields to 1,024 
> characters but a textarea can hold a lot more.
>
> In my experience with FMSA7, URLs (and forms with METHOD=GET) are 
> limited to somewhere around 512 characters for the total length of 
> the URL.
>
> Greg
>
>
> On May 16, 2005, at 9:21 PM, Dave Strickler wrote:
>
> > I tried a few experiments, and although I didn't trap down an exact 
> > numbers of characters, the POST (yes, I tried changing it from GET) 
> > seems to have the same issues as just using the URL. At about +100 
> > characters, the record is not created in FM. Note I am using FLU 
> > v5.0v3
> >
> > Looks like its a problem with using a URL to input 'large' chunks 
> > of data. I don't think its a problem with fx.php.
> >
> > What surprises me is that no one has bucked up again this before? I 
> > am adding in text fields that have the bodies of emails as we use 
> > FM as our CRM. Doesn't seem all that unusual to me. Is it unusually 
> > to add in text like this? Maybe I'm doing things strangely...
> >
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>  
>
>
>
>
>
> ----------------------------
> This message has been certified virus-free by MailWise Filter - The 
> real-time, intelligent, e-mail firewall used to scan inbound and 
> outbound messages for SPAM, Viruses and Content.  For more info visit: 
> http://www.mailwise.com
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list