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.ch com4u.ch http://www.com4u.ch Breitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26 Switzerland------------------------------------------------------------- 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:

    
  1. Re: Moving records (Michael O Shea 2000)
  2. Re: Moving records (Kenneth Grome 2000)
  3. Moving records (Michael O Shea 2000)
> >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.ch com4u.ch http://www.com4u.ch Breitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26 Switzerland------------------------------------------------------------- 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)