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.chcom4u.ch http://www.com4u.chBreitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26Switzerland-------------------------------------------------------------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.chcom4u.ch http://www.com4u.chBreitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26Switzerland-------------------------------------------------------------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:
shownext (1997)
Searching help needed (1998)
[shownext] and sort (1998)
Configuring E-mail (1997)
Weird NT mail (1998)
Error.html (1997)
Frames and WebCat (1997)
Multiple catalog databases and showcart (1997)
hidden databases (2000)
Associative lookup style? + bit more (1997)
killing white space (1998)
Time Remaining? (1998)
HTML text cannot be copied to clipboard? (1999)
[FoundItems] solved - thanks (1997)
Cookie problems using Mozilla and Camino browsers (2004)
2.0Beta Command Ref (can't find this instruction) (1997)
WebCommerce: Folder organization ? (1997)
format crash! (1997)
PCS Frames (1997)
A Global Variable (1997)