Re: [WebDNA] merging multiple database fields into a new field
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 112705
interpreted = N
texte = 288 Have a look at www.webdna.us, menu "community": you will see your posts = and replies, if any. - chris > On Apr 1, 2016, at 01:56, Rich Kwas
wrote: >=20 > Seems 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...... >=20 >=20 >=20 > SOLVED >=20 > Poked around in my StandardConversions.db and the following works as I = need. >=20 >=20 > [append = db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2][/url][c= onvertchars]%0D[/convertchars][url][text4][/url][/append] >=20 >=20 > My original post about this..... >=20 > =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 into one large text field. = (making a new db for a site re-design) >=20 > 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. >=20 > >=20 >=20 > But I have thousands of listings where these multiple fields need to = be merged into one new field.... >=20 > If I create a new db from the old by merging/appending like this >=20 > [append = db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/= url][/append] >=20 > 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. >=20 > 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? >=20 > Looking at my old .db I see a "VT" in a black box, that being the line = break/carriage return. > --------------------------------------------------------- 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 --------------------------------------------------------- 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 .
Associated Messages, from the most recent to the oldest:
288 Have a look at www.webdna.us, menu "community": you will see your posts = and replies, if any. - chris > On Apr 1, 2016, at 01:56, Rich Kwas wrote: >=20 > Seems 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...... >=20 >=20 >=20 > SOLVED >=20 > Poked around in my StandardConversions.db and the following works as I = need. >=20 >=20 > [append = db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2][/url][c= onvertchars]%0D[/convertchars][url][text4][/url][/append] >=20 >=20 > My original post about this..... >=20 > =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 into one large text field. = (making a new db for a site re-design) >=20 > 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. >=20 > >=20 >=20 > But I have thousands of listings where these multiple fields need to = be merged into one new field.... >=20 > If I create a new db from the old by merging/appending like this >=20 > [append = db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/= url][/append] >=20 > 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. >=20 > 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? >=20 > Looking at my old .db I see a "VT" in a black box, that being the line = break/carriage return. > --------------------------------------------------------- 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 --------------------------------------------------------- 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 .
christophe.billiottet@webdna.us
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:
Help formatting search results w/ table (1997)
[WebDNA] Anyone using CODA ?? (2012)
webcat NT (1998)
[searchString] (1997)
Running 2 two WebCatalog.acgi's (1996)
[append] vs. [appendfile] delta + question? (1997)
Server Freeze (1998)
setlineitem quantity to zero? (2000)
Running subtotal? (1998)
SiteGuard Use Question (1997)
Bannerad Demo (1998)
help with duplicate records posted (1998)
Re:no [search] with NT (1997)
a search based on ^(contains) (1998)
Cart Numbers (1997)
[WebDNA] Best WebDNA version for OS X Server 10.5.8 on PowerPC? (2010)
Problem with updating 2.1b7 -> 2.1.1 (1998)
Bug Report, maybe (1997)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
Server Load (2000)