Re: Req: Row DB feature

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55942
interpreted = N
texte = Palle- Give this a try: [search db=x.db&eqwhatever-paramaters-uniquely-identify-the-row-you-want-to-copy-data=T] [founditems] [append db=y.db]cart=[cart]&[listfields db=x.db]&[fieldname]=[interpret][fieldname][/interpret][/listfields][/append] [/founditems] [/search] If you have 5.x, you can use the autonumber feature to assign this new record the appropriate id number. Regards, Will Starck -- NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com 817-431-8437 On Sun, 8 Feb 2004 17:01:52 +0100, Palle Bo Nielsen wrote: > Hi all, > > Maybe some of you WebDNA developers can help me out here. I am > looking for a nifty trick which can spare me for a lot of work. Maybe > it already exists maybe not... > > What I would like to do is copying an entire row from database X > (x.db) and append the complete row to a new database (y.db) without > having to do the whole append procedure with all the < > aaa=[aaa]&bbb=[bbb]&ccc=[ccc]...etc > > > Simply a short function or something similar which can copy an entire > and specified row and paste it into a new DB. The new DB will have a > new Column width a new unique field identifier. > > Explained in another way... > > Copy from x.db (identified by the unique field 'aaa' in this DB) > aaa bbb ccc ddd eee fff > > And paste it into y.db ('xxx' is a new unique cart identifier in this DB) > xxx aaa bbb ccc ddd eee fff > > > Hope someone can help... > > Palle > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Req: Row DB feature ( Palle Bo Nielsen 2004)
  2. Re: Req: Row DB feature ( Donovan Brooke 2004)
  3. Re: Req: Row DB feature ( WJ Starck 2004)
  4. Re: Req: Row DB feature ( Donovan Brooke 2004)
  5. Re: Req: Row DB feature ( WJ Starck 2004)
  6. Req: Row DB feature ( Palle Bo Nielsen 2004)
Palle- Give this a try: [search db=x.db&eqwhatever-paramaters-uniquely-identify-the-row-you-want-to-copy-data=T] [founditems] [append db=y.db]cart=[cart]&[listfields db=x.db]&[fieldname]=[interpret][fieldname][/interpret][/listfields][/append] [/founditems] [/search] If you have 5.x, you can use the autonumber feature to assign this new record the appropriate id number. Regards, Will Starck -- NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com 817-431-8437 On Sun, 8 Feb 2004 17:01:52 +0100, Palle Bo Nielsen wrote: > Hi all, > > Maybe some of you WebDNA developers can help me out here. I am > looking for a nifty trick which can spare me for a lot of work. Maybe > it already exists maybe not... > > What I would like to do is copying an entire row from database X > (x.db) and append the complete row to a new database (y.db) without > having to do the whole append procedure with all the < > aaa=[aaa]&bbb=[bbb]&ccc=[ccc]...etc > > > Simply a short function or something similar which can copy an entire > and specified row and paste it into a new DB. The new DB will have a > new Column width a new unique field identifier. > > Explained in another way... > > Copy from x.db (identified by the unique field 'aaa' in this DB) > aaa bbb ccc ddd eee fff > > And paste it into y.db ('xxx' is a new unique cart identifier in this DB) > xxx aaa bbb ccc ddd eee fff > > > Hope someone can help... > > Palle > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ WJ Starck

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:

Can I do these? (1997) wild question (1998) WebCatalog as a ListServ (1998) Order problem (1998) multi-paragraph fields (1997) Upgrading old WebCat Database Files (1997) [WebDNA] MATH shortcut (2014) too many nested tags ... (1997) [WebDNA] passing a variable in an include - precedence (2015) range searching (1998) read and write you own cookies with webcat (1997) Database Security (1998) Width & Height (1998) Order not created error (1997) WebCat2b12 - nesting [tags] (1997) UPPERCASE (1997) Date Help (2004) [WebDNA] Create a cryptographic Mac key... (2016) Initiating NewCart (1997) MySQL and Numbers (2005)