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:
Google MAP URLs (2006)
No spaces allowed in text variable names ... ? (2002)
Shipping calculations (1997)
WebCat2_Mac RETURNs in .db (1997)
Help with Shipping Costs (1997)
Dynamic Pop up menu? (1997)
textarea inputs and returns - sending HTML email (1999)
File Upload (1997)
What does this error mean? (2000)
Listserver problem (1997)
ConverChars (1999)
checking for [ and ] in form fields ... (1997)
Sorting problem (1997)
How to Display text in empty fields (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
switching users (1998)
Next (1997)
Multiple catalog databases and showcart (1997)
Searching help needed (1998)