[FX.php List] Combining checkbox values to write to a single FMfield

[Derrick Fogle]

All my stuff - servers and authoring environment - is OSX. I've found  
that when dealing with FMP and FX.php, \r alone is what translates  
into a pilcrow in FileMaker; using \n doesn't produce the pilcrow.  
Furthermore, I've found that my configuration returns picrows as \n -  
not \r. So if I get something out of FMP that I need to retain  
pilcrows and send back, I've got to

$instance ->AddDBParam("FieldName" , str_replace("\n", "\r",  
$DataFromFXphp ) );

...if I stuff data back into FMP.

This seems crazy, and I'd be surprised if other people's setups are  
doing this, but mine sure is. It's not hard to test to verify what  
works correctly for you, then stick with that.

On Oct 30, 2006, at 12:06 PM, Gjermund Gusland Thorsen wrote:

> This is how it should work, if I remember correctly
> ---
> \r\n = Windows 95 - 2000
> \n = Unicode ( MacOS X, WinXP, Linux, and Unix platforms )
> \r = MacOS 9
> ---
> ggt667
>
> On 10/30/06, Andrew Denman <adenman at tmea.org> wrote:
>> '\r\n' between each value works for me.
>>
>> Andrew Denman
>>
>> -----Original Message-----
>> From: fx.php_list-bounces at mail.iviking.org
>> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
>> Sent: Thursday, October 26, 2006 4:16 PM
>> To: FX.php Discussion List
>> Subject: [FX.php List] Combining checkbox values to write to a single
>> FMfield
>>
>> I know this has to be simple...
>>
>> I've got a form where there are 19 possible checkboxes, all of which
>> need to write to a single field in FileMaker. I've pulled values into
>> the form without any trouble (I use strpos to do this, might not be
>> the easiest, but it works); to write back to the database with edited
>> data, I need to combine my values
>>
>> $feature1
>> $feature2
>> $feature3
>>
>> I tried doing this
>>
>> $feature = $feature1.'\n'.$feature2.'\n'.$feature3;
>>
>> but that doesn't give me
>>
>> Value 1
>> Value 2
>> Value 3
>>
>> which is what FileMaker wants to see. What do I need to put between
>> my variables to concatenate them properly? I've tried using '<br>'
>> but that doesn't work either.
>>
>> I know this is simple, but my brain can't grok it...
>>
>> Thanks,
>>
>> Bob Patin
>> Longterm Solutions
>> bob at longtermsolutions.com
>> 615-333-6858
>> http://www.longtermsolutions.com
>>
>>    CONTACT US VIA INSTANT MESSAGING:
>>       AIM or iChat: longterm1954
>>       Yahoo: longterm_solutions
>>       MSN: tech at longtermsolutions.com
>>       ICQ: 159333060
>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


Derrick Fogle
derrick at fogles.net