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

[Kevin Futter]

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.