Re: Moving records
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28600
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 deleteNo, 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 ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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 deleteNo, 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 ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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
Kenneth Grome
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:
suggestion (1997)
[ot] G5 Desktop as Server (2004)
Dummy Credit Card Number for debug? (1997)
practicing safe queries.. (2000)
SSL, WebSTAR, WebCatalog (1998)
Doing VALIDCARD right? (1998)
Re:Running 2 two WebCatalog.acgi's (1996)
CyberCash on OS X (2005)
Linux Beta4 problems with multirecord returns (2000)
External RAID (2005)
CentOS (was Fedora Core 6) (2007)
[WebDNA] DB problem solved (2011)
WebCatalog for Postcards ? (1997)
Bug Report, maybe (1997)
Cart Already Submitted (2003)
Locking up with WebCatalog... (1997)
Quitting WebMerchant ? (1997)
Smith Micro - no competition (2000)
[searchString] (1997)
Generating Report Totals (1997)