[FX.php List] Submitting line breaks into FM field?

[Troy Meyers]

Kevin,

Maybe you are looking for this:

http://www.php.net/manual/en/function.nl2br.php

I believe it you do that to the field data before sending to the browser it'll remain line-formatted as it was in the field.

-Troy


> Hi all,
> 
> In my day-to-day FX & FM work, I do a lot of reading from databases,
> but not a great deal of data submission, and what there is tends to be
> check boxes, radio buttons and select menus.
> 
> Today I find myself needing to submit a multi-line data set into a
> field in FM, but it goes in without line breaks - basically one long
> string. The data is stored in the script as an array, and I use
> something like the following to get it into the database:
> 
> $parsedLog = implode(chr(10), $log);
> 
> ...
> 
> $FMSubmit->AddDBParam("log", $parsedLog);
> 
> However, either FileMaker or FX is stripping the line breaks out before
> dumping the data into the field. They're definitely there, because if I
> run this line:
> 
> $parsedLog = str_replace(chr(10), " ! ", $parsedLog);
> 
> I end up with exclamation marks in the field, though doubled-up for some
> reason I can't fathom.
> 
> A colleague has successfully imported data into FM from mySQL that
> contained ASCII 10 for formatting purposes, so it's either a 'feature'
> in FX or a limitation in FM's XML interface (or something else I'm not
> even aware of).
> 
> Can anybody offer any clues?
> 
> (FWIW, I've got a temporary fix that runs a find/replace script in FM,
> replacing the string "<break>" with a pilcrow.)
> 
> -- 
> 
> Kevin Futter
> 
> Webmaster, St. Bernard's College
> 
> http://www.sbc.melb.catholic.edu.au/
> 
> #####################################################################################
> This e-mail message has been scanned for Viruses and Content and cleared
> by MailMarshal
> 
> #####################################################################################
> 
> This e-mail and any attachments may be confidential. You must not
> disclose or use the information in this e-mail if you are not the
> intended recipient. If you have received this e-mail in error, please
> notify us immediately and delete the e-mail and all copies. The College
> does not guarantee that this e-mail is virus or error free.  The
> attached files are provided and may only be used on the basis that the
> user assumes all responsibility for any loss, damage or consequence
> resulting directly or indirectly from the use of the attached files,
> whether caused by the negligence of the sender or not. The content and
> opinions in this e-mail are not necessarily those of the College.
> 
> _______________________________________________
> 
> FX.php_List mailing list
> 
> FX.php_List at mail.iviking.org
> 
> http://www.iviking.org/mailman/listinfo/fx.php_list