---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listSeems I'm not getting any of the talklist posts t=o either of my 2 emails again....Happens a lot with my yahoo acc=ount, just occurred now as well with gmail.....Can't answer =myquestion without created a new post......
=div>SOLVEDPoked around in my =StandardConversions.db and the following works as I need.[append db=3D^rs-avs/listings_new.db]ad_=ID=3D[SKU]&comments=3D[url][text2][/url][convertchars]%0D[/convertchars=][url][text4][/url][/append]My= original post 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=3DI need to merge multiple text fields into one large text fi=eld. (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 &quo=t;submit" the form, the 13 fields get written into the new database fi=eld just perfectly.<te=xtarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" row=s=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[tex=t1][text2][text3][text4][text5]=[text6][text7][text8][text9][text10][text11][text12][text13]=div></textarea>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 t=his [append db=3D^rs-avs/l=istings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/appen=d]I do get the 2 fiel=ds written OK with text4 following text 2 BUT I there not even any space be=tween the two fields in the merged one. I can't seem to get a line brea=k / carriage return between [text2]&[text4] like I do in the form sampl=e above.Since there reall=y isn't anything between [text2][text4] when I'm doing the append i=s there a way I can place a line break between these fields?Looking at my old .db I see a "VT&=quot; in a black box, that being the line break/carriage return.---------------------------------------------------------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: suppo=rt@webdna.us.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--001a11c3277e3463ca052f66c7dc--. Associated Messages, from the most recent to the oldest:
289--001a11c3277e3463ca052f66c7dcContent-Type: text/plain; charset=UTF-8Hi Rich,I was about to solve your problem but it's only 8 am here, the comunity isworldwide so sometimes answers can take some litle time ;-)Lawrence2016-04-01 0:56 GMT+02:00 Rich Kwas
- Re: ***JUNK MAIL*** Re: [WebDNA] merging multiple database fields into a new field (Michael Davis
2016) - Re: [WebDNA] merging multiple database fields into a new field (Rich Kwas
2016) - Re: [WebDNA] merging multiple database fields into a new field (Stuart Tremain
2016) - Re: [WebDNA] merging multiple database fields into a new field (christophe.billiottet@webdna.us 2016)
- [WebDNA] merging multiple database fields into a new field (Rich Kwas
2016) :> 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......>>>> SOLVED>> Poked 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.> --------------------------------------------------------- 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>--001a11c3277e3463ca052f66c7dcContent-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable LawrenceHi Rich,I was about to solve your pro=blem but it's only 8 am here, the comunity is worldwide so sometimes an=swers can take some litle time ;-)2016-04-01 0:56 GMT+02:00 Rich= Kwas <richkwasniewski@yahoo.com>:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listSeems I'm not getting any of the talklist posts t=o either of my 2 emails again....Happens a lot with my yahoo acc=ount, just occurred now as well with gmail.....Can't answer =myquestion without created a new post......
=div>SOLVEDPoked around in my =StandardConversions.db and the following works as I need.[append db=3D^rs-avs/listings_new.db]ad_=ID=3D[SKU]&comments=3D[url][text2][/url][convertchars]%0D[/convertchars=][url][text4][/url][/append]My= original post 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=3DI need to merge multiple text fields into one large text fi=eld. (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 &quo=t;submit" the form, the 13 fields get written into the new database fi=eld just perfectly.<te=xtarea name=3D"__MERGED_TEXT_COPY" wrap=3D"virtual" row=s=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[tex=t1][text2][text3][text4][text5]=[text6][text7][text8][text9][text10][text11][text12][text13]=div></textarea>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 t=his [append db=3D^rs-avs/l=istings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text4][/url][/appen=d]I do get the 2 fiel=ds written OK with text4 following text 2 BUT I there not even any space be=tween the two fields in the merged one. I can't seem to get a line brea=k / carriage return between [text2]&[text4] like I do in the form sampl=e above.Since there reall=y isn't anything between [text2][text4] when I'm doing the append i=s there a way I can place a line break between these fields?Looking at my old .db I see a "VT&=quot; in a black box, that being the line break/carriage return.---------------------------------------------------------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: suppo=rt@webdna.us.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--001a11c3277e3463ca052f66c7dc--. "Lawrence Banahan - Author's Image"
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:
WebCat editing, SiteGuard & SiteEdit (1997) Whats wrong with this???? (2001) WebDNA Solutions ... sorry! (1997) Running _every_ page through WebCat ? (1997) IP address & domain name problem (2003) Customizing WebDelivery.html (1998) WebCatalog memory error. (1998) Database Updates (1997) Initiating NewCart (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Need help... (1997) I read the manual (2000) Show all from database (2001) Thanks Grant (1997) Emailer Set Up (1997) OT: Backup Strategies (2007) [OT] Browser's search via javascript? (2003) WebCat2: Found Items syntax, etc. (1997) Feature request (1998) File Uploads... (1997)