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:
NetSplat and WebCat2 (1997)
Quitting WebMerchant ? (1997)
RE: E-mailer error codes (1997)
WebCatalog 2.1 for NT (1998)
search zip codes ranges (2003)
problems with 2 tags (1997)
Images in WebCat (2000)
Need help with emailer- 2 issues (1997)
Download URL & access on the fly ? (1997)
System 8.5.1 question (1999)
Spaces in FormVariables (2001)
Multiple catalog databases and showcart (1997)
Help! (2000)
encrypt/decrypt password with authenticate (2002)
[isfile] ? (1997)
why won't this work, please tell me??? (2001)
Almost a there but..bye bye NetCloak (1997)
Sorting by date (1997)
Generating unique SKU from [cart] (1997)
Bug in loop context ... (2000)