1st Line
2nd Line
It gets = [url] when submitting to a DB and getting it back to display either = within a textarea box or just as a text in HTML format to display in = browser is no issue with the correct tags. We will get = =E2=80=A6=E2=80=A6
1st Line
2nd Line
The same DB = data when pushed to a plain text file (Writefile or Sendmail message = body) does not do the carriage thingy at = all.
As an = example (1) =E2=80=A6.
[unurl][DB_da= ta][/unurl] gives this result = =E2=80=A6.
1st Line = 2nd Line
=E2=80=A6.eve= rything on one line.
As an = example (2) =E2=80=A6.
[convertchars= ][unurl][DB_data][/unurl][/convertchars] gives this result = =E2=80=A6.
1st Line<br>2nd Line
=E2=80=A6.eve= rything on one line with br tag where a carriage return is supposed to = be.
I think I = need a custom conversion DB to get things right. Seen it mentioned in = archive Talklist that folks created called EmailMime.db, etc. = =E2=80=A6but cannot find it to test it = out.
Anyone out = there can help me out on this issue would be most appreciated. Again, no = issue DB/HTML or Textarea interchange. Just DB output to plain text file = =E2=80=A6how do I get the Db data to convert stored carriage return = correctly.
------------= --------------------------------------------- This message is sent to = you because you are subscribed to the mailing list talk@webdna.us To = unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug = Reporting: support@webdna.us
-------------------------------------------------------= -- This message is sent to you because you are subscribed to the mailing = list talk@webdna.us To = unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/p= age.dna?numero=3D55 Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us ------=_NextPart_000_0021_01D572D0.229B6130-- .
Associated Messages, from the most recent to the oldest:
2429 This is a multipart message in MIME format. ------=_NextPart_000_0021_01D572D0.229B6130 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi Stuart, =20 Tried it your way referencing the link. It converts nicely all = characters for a text file output but it still did NOT handle the = carriage return bit. =20 That said, I finally solved the problem. Used a custom DB to convert. = Then applied it as such =E2=80=A6. =20 [convertchars table=3Dcustom_db][Data_From_DB][/convertchars] =20 This did the trick and text file had proper carriage returns between = lines. As for the custom.db =E2=80=A6.what we did was to use the classic = =E2=80=9CStandardConversions.db=E2=80=9D but changed the very parameter = =E2=80=A6. =20 From : %0B To : %0D%0A =20 Essentially overriding
output. The nice thing about it = =E2=80=A6every other character translated correctly like no difference = to the original built in conversion. Totally happy cause it served or = needs where this custom.db is exclusive for handling textarea -> DB -> = text file output. Hope this helps some other folks. =20 Cheers TDn =20 From: Stuart Tremain
=20 Sent: Tuesday, September 24, 2019 08:39 AM To: WebDNA Talk List Subject: Re: [WebDNA] Convert Carriage Return From DB to Plain Text File =20 Hi Terry =20 Have a look at [input] =20 http://webdna.us/page.dna?numero=3D182 =20 =20 Kind regards =20 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@plsoftware.com.au =20 =20 =20 =20 =20 =20 On 24 Sep 2019, at 10:29, Terry Nair > wrote: =20 Going bonkers trying to figure this out using [convertchars]. =20 As an example, we have a textarea with the following; =20 1st Line 2nd Line =20 It gets [url] when submitting to a DB and getting it back to display = either within a textarea box or just as a text in HTML format to display = in browser is no issue with the correct tags. We will get = =E2=80=A6=E2=80=A6 =20 1st Line 2nd Line =20 The same DB data when pushed to a plain text file (Writefile or Sendmail = message body) does not do the carriage thingy at all. =20 =20 As an example (1) =E2=80=A6. =20 [unurl][DB_data][/unurl] gives this result =E2=80=A6. =20 1st Line 2nd Line =20 =E2=80=A6.everything on one line. =20 =20 As an example (2) =E2=80=A6. =20 [convertchars][unurl][DB_data][/unurl][/convertchars] gives this result = =E2=80=A6. =20 1st Line
2nd Line =20 =E2=80=A6.everything on one line with br tag where a carriage return is = supposed to be. =20 =20 I think I need a custom conversion DB to get things right. Seen it = mentioned in archive Talklist that folks created called EmailMime.db, = etc. =E2=80=A6but cannot find it to test it out. =20 Anyone out there can help me out on this issue would be most = appreciated. Again, no issue DB/HTML or Textarea interchange. Just DB = output to plain text file =E2=80=A6how do I get the Db data to convert = stored carriage return correctly. =20 Many thanks folks Terry Nair =20 =20 =20 =20 =20 --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us =20 --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us =20 ------=_NextPart_000_0021_01D572D0.229B6130 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi = Stuart,
Tried it = your way referencing the link. It converts nicely all characters for a = text file output but it still did NOT handle the carriage return = bit.
That said, I = finally solved the problem. Used a custom DB to convert. Then applied it = as such =E2=80=A6.
[convertchars= table=3Dcustom_db][Data_From_DB][/convertchars]
This did the = trick and text file had proper carriage returns between lines. As for = the custom.db =E2=80=A6.what we did was to use the classic = =E2=80=9CStandardConversions.db=E2=80=9D but changed the very parameter = =E2=80=A6.
From : = %0B
To : = %0D%0A
Essentially = overriding <br> output. The nice thing about it =E2=80=A6every = other character translated correctly like no difference to the original = built in conversion. Totally happy cause it served or needs where this = custom.db is exclusive for handling textarea -> DB -> text file = output. Hope this helps some other folks.
Cheers = TDn
From:<= /b> = Stuart Tremain <webdna@plsoftware.com.au>
Sent: = Tuesday, September 24, 2019 08:39 AM
To: WebDNA Talk List = <talk@webdna.us>
Subject: Re: [WebDNA] Convert Carriage = Return From DB to Plain Text File
Hi = Terry
As an = example, we have a textarea with the = following;