[WebDNA] merging multiple database fields into a new field

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112703
interpreted = N
texte = 286 ------=_Part_680437_161304824.1459463691162 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit I need to merge multiple text fields into one large text field. (making a new db for a site re-design) I can do it very easily via a form one by one with input fields like this, showing multiple text fields in a new text area, and then when I "submit" the form, the 13 fields get written into the new database field just perfectly. But I have thousands of listings where these multiple fields need to be merged into one new field.... If I create a new db from the old by merging/appending like this [append db=^rs-avs/listings_new.db]ad_ID=[SKU]&ad_text=[url][text2][text4][/url][/append] I do get the 2 fields written OK with text4 following text 2 BUT I there not even any space between the two fields in the merged one. I can't seem to get a line break / carriage return between [text2]&[text4] like I do in the form sample above. Since there really isn't anything between [text2][text4] when I'm doing the append is there a way I can place a line break between these fields? Looking at my old .db I see a "VT" in a black box, that being the line break/carriage return. ------=_Part_680437_161304824.1459463691162 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I need to merge multiple text fields into one large text field. (making a = new db for a site re-design)

I can do it very easily via a form one by one with input fields like th= is, showing multiple text fields in a new text area, and then when I "submi= t" the form, the 13 fields get written into the new database field just per= fectly.
<= br>
<t= extarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" rows=3D"75" cols=3D"12= 5">
ALL OF THE= COPY IN THIS AD:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
[text1]
[text2]
[text3]
[text4]
[text5]
[text6]
[text7]
= [text8]
[text9]
=
[text10]
[text11]
[text12]
[text13]
</textarea>


But I have thousan= ds of listings where these multiple fields need to be merged into one new f= ield....

= If I create a new db from the old by merging/appending like this

[append db=3D^rs-avs/= listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/appe= nd]
<= br>
I do = get the 2 fields written OK with text4 following text 2 BUT I there not eve= n any space between the two fields in the merged one. I can't seem to get a= line break / carriage return between [text2]&[text4] like I do in the = form sample above.

Since there really isn't anything between [text2][text4] when I'm doi= ng the append is there a way I can place a line break between these fields?=

Looking at m= y old .db I see a "VT" in a black box, that being the line break/carriage r= eturn.


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_680437_161304824.1459463691162-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: ***JUNK MAIL*** Re: [WebDNA] merging multiple database fields into a new field (Michael Davis 2016)
  2. Re: [WebDNA] merging multiple database fields into a new field (Rich Kwas 2016)
  3. Re: [WebDNA] merging multiple database fields into a new field (Stuart Tremain 2016)
  4. Re: [WebDNA] merging multiple database fields into a new field (christophe.billiottet@webdna.us 2016)
  5. [WebDNA] merging multiple database fields into a new field (Rich Kwas 2016)
286 ------=_Part_680437_161304824.1459463691162 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit I need to merge multiple text fields into one large text field. (making a new db for a site re-design) I can do it very easily via a form one by one with input fields like this, showing multiple text fields in a new text area, and then when I "submit" the form, the 13 fields get written into the new database field just perfectly. But I have thousands of listings where these multiple fields need to be merged into one new field.... If I create a new db from the old by merging/appending like this [append db=^rs-avs/listings_new.db]ad_ID=[SKU]&ad_text=[url][text2][text4][/url][/append] I do get the 2 fields written OK with text4 following text 2 BUT I there not even any space between the two fields in the merged one. I can't seem to get a line break / carriage return between [text2]&[text4] like I do in the form sample above. Since there really isn't anything between [text2][text4] when I'm doing the append is there a way I can place a line break between these fields? Looking at my old .db I see a "VT" in a black box, that being the line break/carriage return. ------=_Part_680437_161304824.1459463691162 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I need to merge multiple text fields into one large text field. (making a = new db for a site re-design)

I can do it very easily via a form one by one with input fields like th= is, showing multiple text fields in a new text area, and then when I "submi= t" the form, the 13 fields get written into the new database field just per= fectly.
<= br>
<t= extarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" rows=3D"75" cols=3D"12= 5">
ALL OF THE= COPY IN THIS AD:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
[text1]
[text2]
[text3]
[text4]
[text5]
[text6]
[text7]
= [text8]
[text9]
=
[text10]
[text11]
[text12]
[text13]
</textarea>


But I have thousan= ds of listings where these multiple fields need to be merged into one new f= ield....

= If I create a new db from the old by merging/appending like this

[append db=3D^rs-avs/= listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/appe= nd]
<= br>
I do = get the 2 fields written OK with text4 following text 2 BUT I there not eve= n any space between the two fields in the merged one. I can't seem to get a= line break / carriage return between [text2]&[text4] like I do in the = form sample above.

Since there really isn't anything between [text2][text4] when I'm doi= ng the append is there a way I can place a line break between these fields?=

Looking at m= y old .db I see a "VT" in a black box, that being the line break/carriage r= eturn.


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_680437_161304824.1459463691162-- . Rich Kwas

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Nav. 4 probs with cart (1997) service stop and restart (1997) Authenticate (1997) Sorting by date (1997) Bad match! (2002) ReturnRaw context (1997) Webcatalog, Webstar and Crasharama (1999) [ShowNext] feature in 2.0 (1997) [quantity] within formulas (1997) is your webDNA site 'froogle' ready ??? (2003) Applescript Hack (1996) math on date? (1997) Date problem still... (2004) Location of Browser Info.txt file (1997) Archives are missing (2003) Part 2 - [showif] if variable exists (1998) Browser frames and URLs in the Location field (2004) List archive status? (1999) page redirect in webDNA (1997) 256 character limit in URL? Kinda urgent... (2004)