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:
WebCat2 - Getting to the browser's username/password data (1997)
New global preference ... ??? (2000)
Storebuilder, Smith-Micro Tech Support (2000)
WebCat2.0 [format thousands .0f] no go (1997)
Bug Report, maybe (1997)
[IpAddress] Tag (1997)
totals (1997)
Seeking WebCat Bulletin Board (1999)
CMSBuilder (2004)
Execute Applescript (1997)
WebCat2 several catalogs? (1997)
taxRate is fine but taxTotal isn't (1997)
Frames and WebCat (1997)
[showif] Saturday won't work (2007)
.htm file tags not showing up (2000)
Multiple 'Users.db' files not possible (1997)
Pgp&emailer (1997)
Date fun with MySQL (2004)
Multiple prices (1997)
getting images' width/height (1998)