[WebDNA] Re: merging multiple database fields into a new field
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 112704
interpreted = N
texte = 287------=_Part_699231_538408982.1459465017039Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitSeems I'm not getting any of the talklist posts to either of my 2 emails again....Happens a lot with my yahoo account, just occurred now as well with gmail.....Can't answer myquestion without created a new post......SOLVEDPoked around in my StandardConversions.db and the following works as I need.[append db=^rs-avs/listings_new.db]ad_ID=[SKU]&comments=[url][text2][/url][convertchars]%0D[/convertchars][url][text4][/url][/append]My original post about this.....=========================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_699231_538408982.1459465017039Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable
Seems I'm not getting any of the talklist posts to either of my 2 emails a=gain....
Happens a lo=t with my yahoo account, just occurred now as well with gmail.....
Can't answer myquestion witho=ut created a new post......
SOLVED
Poked around in my StandardConversions.db and the following works as I =need.
[append db=3D^rs-avs/listings_new.d=b]ad_ID=3D[SKU]&comments=3D[url][text2][/url][convertchars]%0D[/convert=chars][url][text4][/url][/append]
My original pos=t about this.....
=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
I need to merge multiple text fields i=nto 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 li=ke 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 jus=t perfectly.
<textarea name=3D"__MERGED_T=EXT_COPY" wrap=3D"virtual" rows=3D"75" cols=3D"125">
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]
[t=ext7]
[text8]
[text9] But I have thousands of listings where these multip=le fields need to be merged into one new field....
[append db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][tex=t2][text4][/url][/append]
=div>
I do get the 2 fields written OK with text4 f=ollowing text 2 BUT I there not even any space between the two fields in th=e merged one. I can't seem to get a line break / carriage return between [t=ext2]&[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 fie=lds?
Looking at my old .db I see a "VT" in a= black box, that being the line break/carriage return.
=html>---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us------=_Part_699231_538408982.1459465017039--.
Associated Messages, from the most recent to the oldest:
287------=_Part_699231_538408982.1459465017039Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitSeems I'm not getting any of the talklist posts to either of my 2 emails again....Happens a lot with my yahoo account, just occurred now as well with gmail.....Can't answer myquestion without created a new post......SOLVEDPoked around in my StandardConversions.db and the following works as I need.[append db=^rs-avs/listings_new.db]ad_ID=[SKU]&comments=[url][text2][/url][convertchars]%0D[/convertchars][url][text4][/url][/append]My original post about this.....=========================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_699231_538408982.1459465017039Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printableSeems I'm not getting any of the talklist posts to either of my 2 emails a=gain....
Happens a lo=t with my yahoo account, just occurred now as well with gmail.....
Can't answer myquestion witho=ut created a new post......
SOLVED
Poked around in my StandardConversions.db and the following works as I =need.
[append db=3D^rs-avs/listings_new.d=b]ad_ID=3D[SKU]&comments=3D
[url][text2][/url]
[convertchars]%0D[/convert=chars]
[url][text4][/url][/append]
My original pos=t about this.....
=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
I need to merge multiple text fields i=nto 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 li=ke 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 jus=t perfectly.
<textarea name=3D"__MERGED_T=EXT_COPY" wrap=3D"virtual" rows=3D"75" cols=3D"125">
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]
[t=ext7]
[text8]
[text9][text10]
[text11]
[text12]
[t=ext13]
</textarea&=gt;
But I have thousands of listings where these multip=le 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=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D
[url][tex=t2][text4][/url][/append]
=div>
I do get the 2 fields written OK with text4 f=ollowing text 2 BUT I there not even any space between the two fields in th=e merged one. I can't seem to get a line break / carriage return between [t=ext2]&[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 fie=lds?
Looking at my old .db I see a "VT" in a= black box, that being the line break/carriage return.
=html>---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us------=_Part_699231_538408982.1459465017039--.
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:
Resetting a Formvariable (2000)
Million product store (2003)
Trouble with formula.db (1997)
javascript newPopwin and webcat (1998)
Roundup function? (1997)
Protecting Images (2003)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Hosting WebDNA (2006)
Duplicates (1998)
[url] link (1998)
search for all (1998)
Creating a back button (1999)
price carry over (1997)
TeaRoom Order fields email account remain empty even though thewy are filled. (1997)
Use of Back and Reload Buttons on ShoppingCart page? (1997)
Re1000001: Setting up shop (1997)
[WebDNA] How much does it cost now? (2008)
Help formatting search results w/ table (1997)
Re(8): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
Search in 2 or more catalogs (1997)