[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:
converting tabs (1997)
[WebDNA] reCAPTCHA and WebDNA (2010)
searchable list archive (1997)
Problem 2: Prefs file... (1997)
RE: Re:Has this happened to you? (1997)
BR (1997)
FRAMES and CART tags problem??!? (1999)
[WebDNA] Listfiles and sort order (2010)
Nitro plugin? (1998)
Clearly.home (1998)
[countWords]? (1997)
PCS Frames (1997)
graphics server, SSL, Netscape 4.0 (off topic) (1998)
Re:Has this happened to you? (1997)
Multiple security dbs (1997)
Emailer question (2003)
RE: Help name our technology! (1997)
OT: javascript print() (2003)
test - ignore (2008)
Prices coming up 0.00 (2001)