Re: [WebDNA] copy some database fields into a new database

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112686
interpreted = N
texte = 269------=_Part_5012732_55736898.1458870481126Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: quoted-printableI have a feeling I over thought the whole thing.Thanks for setting me strai=ght....=20 On Thursday, March 24, 2016 5:29 PM, Brian Burton w=rote:=20 Rich,=20In your example, you don=E2=80=99t need to use a loop at all. The [foundite=ms] tag set is doing the looping for you, one iteration per record retrieve=d.You do however need to add all the fields you want to append in the append =tag.example:=20[search db=3Dproducts.db&eqVisibledatarq=3DT&asSKUsort=3D1][founditems][append db=3Dproducts_new.db&autonumber=3DID]sku=3D[sku]&color=3D[color]&si=ze=3D[size]&price=3D[price]&description=3D[url][description][/url][/append][/founditems][/search]-Brian B. Burton---------------------------------------------------------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_5012732_55736898.1458870481126Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable

I have a f=eeling I over thought the whole thing.

Thanks for setting me straight....

=

On Thursday, Mar=ch 24, 2016 5:29 PM, Brian Burton <brian@burtons.com> wrote:

Rich,

In your exa=mple, you don=E2=80=99t need to use a loop at all. The [founditems] tag set= is doing the looping for you, one iteration per record retrieved.
You do however need to add all the fields you want to append in t=he append tag.
example:

[search db=3Dproducts.db&eqVisibledatarq=3DT&asSKUsort=3D1][founditems]
[append db=3Dproducts_new.db=&autonumber=3DID]sku=3D[sku]&color=3D[color]&size=3D[size]&=price=3D[price]&description=3D[url][description][/url][/append]
[/founditems]
[/search]


-Brian B. Burton


-------------------------------------------=--------------
This message is sent to you because you ar=e subscribed to
the mailing list <talk@webdna.=us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>

archives: http://mail.webdna.us/list/t=alk@webdna.us
Bug Reporting: support@we=bdna.us