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:
PIXO (1997)
Search Folder? (1998)
Email within tmpl ? (1997)
total number of matches (1999)
too many nested tags ... (1997)
PCS Frames (1997)
Upgrading old WebCat Database Files (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
CommandSecurity? (1997)
Date search - yes or no (1997)
WebCatalog f2 Installation (1997)
protect tag on NT IIS (1997)
HTML Editors (1997)
Languages (1997)
Looking for WebCat developer/contractor (2000)
[WebDNA] Credit card processing (2012)
template not found error (1998)
Appendfile memory usage (redux) (2003)
Email (1998)
Formating found categories (1997)