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 Sciencehttp://www.novaderm.comwjs@novaderm.com817-431-8437On 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:
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 Sciencehttp://www.novaderm.comwjs@novaderm.com817-431-8437On 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)