Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23343
interpreted = N
texte = Thanks, I will give this a try. Gil Poulsen wrote:> Well, yes, it is completely replacing existing records with new ones. I > misunderstood your question. In your case you would want to use the > replace context instead and just specify the key field (in my example, > it is the sku) and the price field. So assuming that both databases have > fields called [price] and [sku], it would look more like this: > > [search db=newrecords.db&neskudatarq=[blank]&max=8000] > > [FoundItems] > > [Replace db=yourdatabase.db&eqskudatarq=[sku]]price=[price][/Replace] > > [/FoundItems] > >
[numfound] records have been updated per your request. > > [/search] > > The other fields in the database should remain as they are; at least > they do for me, but if you read the docs it says they will be set to > blank, so maybe PCS can clarify this for us. >
Associated Messages, from the most recent to the oldest:
Thanks, I will give this a try. Gil Poulsen wrote:> Well, yes, it is completely replacing existing records with new ones. I > misunderstood your question. In your case you would want to use the > replace context instead and just specify the key field (in my example, > it is the sku) and the price field. So assuming that both databases have > fields called [price] and [sku], it would look more like this: > > [search db=newrecords.db&neskudatarq=[blank]&max=8000] > >
[founditems] > > [Replace db=yourdatabase.db&eqskudatarq=[sku]]price=[price][/Replace] > > [/FoundItems] > >
[numfound] records have been updated per your request. > > [/search] > > The other fields in the database should remain as they are; at least > they do for me, but if you read the docs it says they will be set to > blank, so maybe PCS can clarify this for us. >
Mike Eberly
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:
RE: E-mailer error codes (1997)
Doesn't change (WebCat 4.0) (2000)
Shopping Cart Page (1997)
RE: WebCatalog2 for NT Beta Request (1997)
Shopping Cart Problem (1998)
Re:HTTP header line is too long? (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
WebTen Type 2 Crash on start (2000)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Server slowing down. (1997)
Spaces in sendmail (1998)
Clean source code (2007)
[WebDNA] Need Rosetta to install on OS X? (2010)
Return records from another (1997)
[BoldWords] WebCat.acgib15Mac (1997)
Summing fields (1997)
Thanks SMSI (2003)
HEADER AND FOOTER (1997)
Not reading code (1997)
[convertchars] problem... (2000)