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:
No Wanna Duppys (1998)
Undocumented changes create problems in webcat 4 ... (2000)
formvariables not passing (2000)
WC2.0 Memory Requirements (1997)
Emailer help....! (1997)
New servers and new inline cache (1997)
LOOP and IF statements (1997)
Webmerch Error (1998)
new server, can't use [writefile] - code attached [long] (2004)
Using Plug-In while running 1.6.1 (1997)
Support ?? (1997)
upgrading (1997)
blank page from template (1997)
search for all (1998)
Free WebDNA snippets (Extending WebCatalog) (1997)
Re:Running 2 two WebCatalog.acgi's (1996)
Searching Multiple DBs (1997)
Summing fields (1997)
Showif, Hideif reverse logic ? (1997)
[shownext max=?] armed (1997)