Re: [WebDNA] Copy a whole row from a db to another db or table
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113856
interpreted = N
texte = 1451> Is there a easier way to copy a data set from a db or table to> another db or table?Yes there is. Use listfields instead of identifying each fieldindividually. Here's the actual copy-and-paste code:[search db=3Ddb/artikel.db&neiddatarq=3D[art_id]][founditems][append table=3Dnewtable][listfields db=3Ddb/artikel.db][!][/!]&[fieldname]=3D[!][/!][url][interpret][[fieldname]][/interpret][/url][!][/!][/listfields][/append][/founditems][/search]Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 12/13/2017 09:57 AM, Noah Valley wrote:> Hi>=20> Is there a easier way to copy a data set from a db or table to> another db or table?> (Both have the same headers =E2=80=9Cid=E2=80=9D, =E2=80=9Ctitle=E2=80=9D=, =E2=80=9Cimage=E2=80=9D,...)> [search db=3Ddb/artikel.db&neiddatarq=3D[art_id]]> [founditems]> [append table=3Dnewtable][!]> [/!]id=3D[id]&title=3D[title]&image=3D[image]&=E2=80=A6[!]> [/!][/append]> [/founditems]> [/search]>=20>=20> Thanks>=20> Noah> --------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reporting:> support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
1451> Is there a easier way to copy a data set from a db or table to> another db or table?Yes there is. Use listfields instead of identifying each fieldindividually. Here's the actual copy-and-paste code:[search db=3Ddb/artikel.db&neiddatarq=3D[art_id]]
[founditems][append table=3Dnewtable][listfields db=3Ddb/artikel.db]
[!][/!]&[fieldname]=3D
[!][/!]
[url][interpret][[fieldname]][/interpret][/url]
[!][/!][/listfields][/append][/founditems][/search]Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 12/13/2017 09:57 AM, Noah Valley wrote:> Hi>=20> Is there a easier way to copy a data set from a db or table to> another db or table?> (Both have the same headers =E2=80=9Cid=E2=80=9D, =E2=80=9Ctitle=E2=80=9D=, =E2=80=9Cimage=E2=80=9D,...)> [search db=3Ddb/artikel.db&neiddatarq=3D[art_id]]>
[founditems]> [append table=3Dnewtable]
[!]> [/!]id=3D[id]&title=3D[title]&image=3D[image]&=E2=80=A6
[!]> [/!][/append]> [/founditems]> [/search]>=20>=20> Thanks>=20> Noah> --------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reporting:> support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Kenneth Grome
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:
Nav. 4 probs with cart (1997)
WebCat2.0 [format thousands .0f] no go (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
2.0 Beta (1997)
WebCat2b13 Command Reference Doc error (1997)
[WebDNA] Generating Excel File Via WebDNA (2010)
Limit on nested [ShowIf]'s? (1997)
PIXO support (1997)
banner ad redirection page (1999)
Bug Report, maybe (1997)
Max Record length restated as maybe bug (1997)
space at start of menu (2000)
Vanity counter side note (1998)
SMSI: WebDNA Versions? (2002)
Size limit for tmpl editor ? (1997)
WebDNA Solutions ... sorry! (1997)
Bug Report, maybe (1997)
OT (sort of) WAP/WML and 'form' posts (2003)
http upload (2001)
[WebDNA] add hours over 24 (2014)