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

[Dave Strickler]

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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20050517/d7c909eb/attachment.html