Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23472
interpreted = N
texte = >OK, I tried the following and it still did not work: > >[search db=newcatalog.db&neskudatarq=[blank]&max=8000] >[FoundItems] >[Replace db=catalogtest.db&sku=[sku]]price=[Price][/Replace] >[/FoundItems] >[numFound] - records have been updated[/search] > >Do I need to give the databases different field names for price (for example, my permanent database would have the field PRICE and the temporary database would have the field NEWPRICE). If so, would I need to do the same with the SKU field?The code is fine, the value of the price and sku tags comes from the values in the newcatalog.db, not from the values in the catalogtest.db. Are you checking the results by opening the db and looking at it manually instead of looking at the results of a new search in an html page? If so, you won't see the changes yet because you haven't saved them to disk with a [commitdatabase] tag after the founditems context.Sincerely, Ken Grome
Associated Messages, from the most recent to the oldest:
>OK, I tried the following and it still did not work: > >[search db=newcatalog.db&neskudatarq=[blank]&max=8000] >
[founditems] >[Replace db=catalogtest.db&sku=[sku]]price=[Price][/Replace] >[/FoundItems] >[numFound] - records have been updated[/search] > >Do I need to give the databases different field names for price (for example, my permanent database would have the field PRICE and the temporary database would have the field NEWPRICE). If so, would I need to do the same with the SKU field?The code is fine, the value of the price and sku tags comes from the values in the newcatalog.db, not from the values in the catalogtest.db. Are you checking the results by opening the db and looking at it manually instead of looking at the results of a new search in an html page? If so, you won't see the changes yet because you haven't saved them to disk with a
[commitdatabase] tag after the founditems context.Sincerely, Ken Grome
Kenneth Grome
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:
# fields limited? (1997)
WCS Newbie question (1997)
# of real domains on 1 web server (1997)
WebMerchant - MacAuthorize (1999)
WebDNA still will not start on restart (2002)
Locking up with WebCatalog... (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Sorting Numbers (1997)
Strange conversions (2001)
Credit card types (1997)
Authenticating users without dialog box (1997)
ShowNext truncating passed variable?? (1997)
WebCommerce: Folder organization ? (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
blank page from template (1997)
off topic - dna snipets (1997)
syntax question, not in online refernce (1997)
Only charge card when product shipped ? (1997)
[searchString] (1997)
experts! - [foundItems] context problem (2000)