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:
Showif, Hideif reverse logic ? (1997)
Quitting WebMerchant ? (1997)
Size/Color Options (2002)
Keyword search (2004)
HTML Editors (1997)
ShowIf variables (1997)
Trouble with formula.db + more explanation (1997)
ShowNext (1997)
GuestBook example (1997)
[OT] MS Security Flaw (2000)
Date search - yes or no (1997)
SQL - Output into file (2004)
Shopping Cart Problem (1998)
[isfile] ? (1997)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
WebCat2 several catalogs? (1997)
ConvertChars? (1998)
WebDNA install - linux (permissions rehash?) (2002)
Mac v. NT (1998)
Quit revisited (1997)