Re: ***JUNK MAIL*** Re: [WebDNA] merging multiple database fields into a new field

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112728
interpreted = N
texte = 311 --Apple-Mail=_3ADF92ED-D598-4664-A18C-64B775A305DF Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Yahoo and AOL have implemented DMARC and that basically breaks a lot of = list servers unless they implement any of a number of hacks. If you = have an email account not associated with either, I recommend using it = for the list. MD > On Apr 1, 2016, at 2:45 AM, Rich Kwas = wrote: >=20 > But I can't reply if I go to that spot on the webpage, I can just read = the posts... >=20 > The original post I made and all the "answers just showed up in my = yahoo email. Weird >=20 > [input][input] wasn't helping.. I was combining multiple records into = one, needing a line break after each one. >=20 > Placing [convertchars]%0D[/convertchars] inbetween the field names = gave me a line break like I wanted. >=20 > It gets frustrating trying to search the talklist archives......=20 > The old ones, the "abyss" are easier to search than the newer posts = over at Mailing list archive >=20 >=20 > Mailing list archive > >=20 >=20 > I'm always pretty sure sure whatever I'm trying to deal with has an = answer or an angle to look at regarding it, just seems difficult at = times to find.=20 >=20 >=20 >=20 >=20 > On Friday, April 1, 2016 12:55 AM, "christophe.billiottet@webdna.us" = wrote: >=20 >=20 > Have a look at www.webdna.us, menu "community": you will see your = posts and replies, if any. >=20 > - chris >=20 >=20 > > 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. >=20 > > --------------------------------------------------------- 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 >=20 > --------------------------------------------------------- > 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 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_3ADF92ED-D598-4664-A18C-64B775A305DF Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Yahoo and AOL have implemented DMARC and that basically = breaks a lot of list servers unless they implement any of a number of = hacks.  If you have an email account not associated with either, I = recommend using it for the list.


MD


On = Apr 1, 2016, at 2:45 AM, Rich Kwas <richkwasniewski@yahoo.com> wrote:

But I can't reply = if I go to that spot on the webpage, I can just read the = posts...

The original post = I made and all the "answers just showed up in my yahoo email. = Weird
[input][input] wasn't helping.. I was combining = multiple records into one, needing a line break after each = one.

Placing [convertchars]%0D[/convertchars] inbetween the = field names gave me a line break like I wanted.

It gets frustrating trying to search the talklist = archives...... 
The old ones, the "abyss" are easier to search = than the newer posts over at Mailing list = archive



I'm = always pretty sure sure whatever I'm trying to deal with has an answer = or an angle to look at regarding it, just seems difficult at times to = find. 




=
On Friday, April = 1, 2016 12:55 AM, "christophe.billiottet@webdna.us" <christophe.billiottet@webdna.us> wrote:


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 = <richkwasniewski@yahoo.com> wrote:
>
> 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=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2][/ur= l][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=3D=
> 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.
>
> <textarea name=3D"__MERGED_TEXT_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]
> [text7]
> [text8]
> [text9]
> [text10]
> = [text11]
> [text12]
> [text13]
> = </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 this
>
> [append = db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text= 4][/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

---------------------------------------------------------
This message is sent to you because you are = subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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

= --------------------------------------------------------- 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 --Apple-Mail=_3ADF92ED-D598-4664-A18C-64B775A305DF-- . Associated Messages, from the most recent to the oldest:

    
311 --Apple-Mail=_3ADF92ED-D598-4664-A18C-64B775A305DF Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Yahoo and AOL have implemented DMARC and that basically breaks a lot of = list servers unless they implement any of a number of hacks. If you = have an email account not associated with either, I recommend using it = for the list. MD > On Apr 1, 2016, at 2:45 AM, Rich Kwas = wrote: >=20 > But I can't reply if I go to that spot on the webpage, I can just read = the posts... >=20 > The original post I made and all the "answers just showed up in my = yahoo email. Weird >=20 > [input][input] wasn't helping.. I was combining multiple records into = one, needing a line break after each one. >=20 > Placing [convertchars]%0D[/convertchars] inbetween the field names = gave me a line break like I wanted. >=20 > It gets frustrating trying to search the talklist archives......=20 > The old ones, the "abyss" are easier to search than the newer posts = over at Mailing list archive >=20 >=20 > Mailing list archive > >=20 >=20 > I'm always pretty sure sure whatever I'm trying to deal with has an = answer or an angle to look at regarding it, just seems difficult at = times to find.=20 >=20 >=20 >=20 >=20 > On Friday, April 1, 2016 12:55 AM, "christophe.billiottet@webdna.us" = wrote: >=20 >=20 > Have a look at www.webdna.us, menu "community": you will see your = posts and replies, if any. >=20 > - chris >=20 >=20 > > 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. >=20 > > --------------------------------------------------------- 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 >=20 > --------------------------------------------------------- > 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 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_3ADF92ED-D598-4664-A18C-64B775A305DF Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Yahoo and AOL have implemented DMARC and that basically = breaks a lot of list servers unless they implement any of a number of = hacks.  If you have an email account not associated with either, I = recommend using it for the list.


MD


On = Apr 1, 2016, at 2:45 AM, Rich Kwas <richkwasniewski@yahoo.com> wrote:

But I can't reply = if I go to that spot on the webpage, I can just read the = posts...

The original post = I made and all the "answers just showed up in my yahoo email. = Weird
[input][input] wasn't helping.. I was combining = multiple records into one, needing a line break after each = one.

Placing [convertchars]%0D[/convertchars] inbetween the = field names gave me a line break like I wanted.

It gets frustrating trying to search the talklist = archives...... 
The old ones, the "abyss" are easier to search = than the newer posts over at Mailing list = archive



I'm = always pretty sure sure whatever I'm trying to deal with has an answer = or an angle to look at regarding it, just seems difficult at times to = find. 




=
On Friday, April = 1, 2016 12:55 AM, "christophe.billiottet@webdna.us" <christophe.billiottet@webdna.us> wrote:


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 = <richkwasniewski@yahoo.com> wrote:
>
> 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=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&comments=3D[url][text2][/ur= l][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=3D=
> 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.
>
> <textarea name=3D"__MERGED_TEXT_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]
> [text7]
> [text8]
> [text9]
> [text10]
> = [text11]
> [text12]
> [text13]
> = </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 this
>
> [append = db=3D^rs-avs/listings_new.db]ad_ID=3D[SKU]&ad_text=3D[url][text2][text= 4][/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

---------------------------------------------------------
This message is sent to you because you are = subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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

= --------------------------------------------------------- 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 --Apple-Mail=_3ADF92ED-D598-4664-A18C-64B775A305DF-- . Michael Davis

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:

WebCommerce: Folder organization ? (1997) Bug? (1997) Hairy Shipping Monster (2006) Running _every_ page through WebCat-error.html (1997) Frames and WebCat (1997) page redirect in webDNA (1997) Converting spaces to + in results list (SOLVED) (2000) Dark Horse Comics success story (1997) WebCat/CyberStudio Compatibility (1998) Weird Math and SV (1997) more re newbie ? re ssl/non-ssl (1999) Search multiple fields (1997) Search with Special Chars (1997) template includes encrypted template (1999) Shipping charges depending on tax rate? (1997) What am I missing (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Help name our technology! (1997) referrer & truncation (1998) So what ya working on? (or have you completed?) (2004)