Re: Moving records
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28601
interpreted = N
texte = > >Is there any easier way to move a record in databaseA.db to > >databaseB.db without, > >1) Doing a search > >2) Doing an append > >3) Doing a delete > >No, that's how you have to do it. > > > >This is painful as I have to specify the fieldnames, as there is no > >way to link [ListFields DatabaseName] to a founditems context. > >Yes there is! Assuming the field names in both db's are the same, >and if you are moving only one record, you can do the following: > >[search db=thisDB&...&max=1] >[founditems] >[append db=otherDB] >[listfields thisDB(or otherDB)] >[fieldname]=[interpret][[fieldname]][/interpret]& >[/listfields] >[/append] >[delete db=thisDB&eqskudata=[sku]] >[/founditems] >[/search] > >Just remember, if you need to retrieve more than one record, you >must move the delete tag outside the founditems context and use a >different technique for the deleting records from thisDB ... :) Thanks for that Ken. I never thought of the [Interpert] tag.Micheal O Shea Email:micheal@com4u.ch com4u.ch http://www.com4u.ch Breitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26 Switzerland------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
> >Is there any easier way to move a record in databaseA.db to > >databaseB.db without, > >1) Doing a search > >2) Doing an append > >3) Doing a delete > >No, that's how you have to do it. > > > >This is painful as I have to specify the fieldnames, as there is no > >way to link [ListFields DatabaseName] to a founditems context. > >Yes there is! Assuming the field names in both db's are the same, >and if you are moving only one record, you can do the following: > >[search db=thisDB&...&max=1] >[founditems] >[append db=otherDB] >[listfields thisDB(or otherDB)] >[fieldname]=[interpret][[fieldname]][/interpret]& >[/listfields] >[/append] >[delete db=thisDB&eqskudata=[sku]] >[/founditems] >[/search] > >Just remember, if you need to retrieve more than one record, you >must move the delete tag outside the founditems context and use a >different technique for the deleting records from thisDB ... :) Thanks for that Ken. I never thought of the [Interpert] tag.Micheal O Shea Email:micheal@com4u.ch com4u.ch http://www.com4u.ch Breitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26 Switzerland------------------------------------------------------------- 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
Michael O Shea
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:
.. more on sliding discounts... (1997)
Frames and WebCat (1997)
Include a big block of text (1997)
Putting Foundvariables within search. (2000)
HomePage Caution (1997)
RE: [WebDNA] Append speed limits (2008)
ShipCost Data Base (1998)
Large Database Issue (possible bug) (2004)
default value from Lookup (was Grant, please help me) (1997)
Re:No Data (1997)
IBM DB2 (2000)
Adding up line items. (2000)
Emailer port change (1997)
Not reading code (1997)
showif comparison begins w/ and contains (1997)
Help Encrypt/Decrypt eMail (2003)
Search in 2 or more catalogs (1997)
Help wanted (1998)
FW: 2.01 upgrade problems (1997)
Converting spaces to + in results list (2000)