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:
searching problem (1998)
PCS Frames (1997)
RE: Formulas.db + Users.db (1997)
Extended [ConvertChars] (1997)
Total found of each unique field (2003)
Web DNA... (2007)
Performance Issue (2000)
How far do [showif]s go? (1997)
send mail problem? (1997)
OSX 10.2.6/iTools 7.0/WebDNA 5.0 installation (2003)
Make sure I understand this??? (1997)
send mail problem? (1997)
GuestBook example (1997)
WCS Newbie question (1997)
RE: Emailer Set Up (1997)
New Site Announcement (1998)
Works! (1997)
createfolder default behavior (1998)
[if] and [showif] - A solution (2002)
Image upload (2000)