[FX.php List] Sending carriage returns within a string into FM field

[Bob Patin]

Right, I'd thought of that, but actually the text is read in to variables, so it never even gets onto the page. So I was taking the value that's read from teh first table, doing some things with it, and then writing it to the 2nd table.

It did occur to me that another method would have been to move the data directly in the database with a script, but this method was working completely, except for the apostrophe problem.

I knew I'd solved this in the past, but I suspect the apostrophe was a curly quote (haven't gone back and looked)... 

Glad to have it all done... clients are testing and I'm happy to have it done!

Best,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting:

On Mar 2, 2011, at 4:54 PM, Head Honcho wrote:

> oops,
> 
> That's for the other way around.  (line breaks out of FileMaker into the web)
> 
> or you could use that and do an auto calc to change the generated <br /> into pilcrows/
> 
> Hope this helps, somewhat.
> 
> Regards
> 
> Michael Ward
> --
> Head Honcho, CustoMike Solutions
> Member, FileMaker Business Alliance & FileMaker Technical Network
> FileMaker 7, 8, 9 & 10 Certified Developer
> ph 0414 562 501
> headhoncho at customikesolutions.com
> 
> On 03/03/2011, at 9:24 AM, Head Honcho wrote:
> 
>> Hi Bob,
>> 
>> try
>> 
>> $create->AddDBParam('item_type', nl2br($values) );
>> 
>> Hope this helps, somewhat.
>> 
>> Regards
>> 
>> Michael Ward
>> --
>> Head Honcho, CustoMike Solutions
>> Member, FileMaker Business Alliance & FileMaker Technical Network
>> FileMaker 7, 8, 9 & 10 Certified Developer
>> ph 0414 562 501
>> headhoncho at customikesolutions.com
>> 
>> On 03/03/2011, at 7:57 AM, Bob Patin wrote:
>> 
>>> Well, merchandise and taxexempt aren't variables, they're text strings...
>>> 
>>> So
>>> 
>>> $merchandise = "merchandise";
>>> $taxexempt = "taxexempt";
>>> $string = $merchandise."\r\n".$taxexempt;
>>> 
>>> is the same as
>>> 
>>> $string = "merchandise\r\ntaxexempt";
>>> 
>>> ... and he was right! I was pretty sure that I'd used \r\n in the past, and the difference was the double-quotes. 
>>> 
>>> I used this: "merchandise\r\ntaxexempt"
>>> 
>>> and it worked perfectly.
>>> 
>>> Thanks guys,
>>> 
>>> Bob Patin
>>> Longterm Solutions
>>> bob at longtermsolutions.com
>>> 615-333-6858
>>> http://www.longtermsolutions.com
>>> iChat: bobpatin
>>> FileMaker 9, 10 & 11 Certified Developer
>>> Member of FileMaker Business Alliance and FileMaker TechNet
>>> --
>>> Expert FileMaker Consulting 
>>> FileMaker Hosting for all versions of FileMaker
>>> PHP • Full email services • Free DNS hosting • Colocation • Consulting:
>>> 
>>> 
>>> 
>>> On Mar 2, 2011, at 2:44 PM, Anders Monsen wrote:
>>> 
>>>> I believe you need to wrap double quotes around a \r
>>>> 
>>>> $values = $merchandise . "\r" . $taxexempt;
>>>> 
>>>> $create->AddDBParam('item_type', $values );
>>>> 
>>> 
>>> _______________________________________________
>>> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20110302/0a65a576/attachment-0001.html