Re: Updating Prices db (still not working)

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23484
interpreted = N
texte = I tried what you suggested with [commitdatabase] but the prices in the catalogtest.db are not being updated. Here is the code that I used:[showif [dbpassword]=MIKE] [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] [COMMITDATABASE catalogtest.db] [/showif] [showif [dbpassword]!MIKE] Sorry, that password is not valid [/showif]You said that the code looks fine. What else could I be doing wrong? Both dbs have an SKU field and a PRICE field. When I link to the template with this code on it it shows 13 records found, so the search command is working fine. Any other suggestions as to what I may be doing wrong?Thank you,Mike Eberly Associated Messages, from the most recent to the oldest:

    
  1. Re: Updating Prices db (still not working) (Gil Poulsen 1999)
  2. Re: Updating Prices db (still not working) (Mike Eberly 1999)
I tried what you suggested with [commitdatabase] but the prices in the catalogtest.db are not being updated. Here is the code that I used:[showif [dbpassword]=MIKE] [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] [COMMITDATABASE catalogtest.db] [/showif] [showif [dbpassword]!MIKE] Sorry, that password is not valid [/showif]You said that the code looks fine. What else could I be doing wrong? Both dbs have an SKU field and a PRICE field. When I link to the template with this code on it it shows 13 records found, so the search command is working fine. Any other suggestions as to what I may be doing wrong?Thank you,Mike Eberly 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:

Webcat/Webmerchant (1998) User/pass with tcpconnect (2000) Typhoon Rev. and PCS store problems (1999) Opinion: [input] should be called [output] ... (1997) WebDNA maxing out processor (2008) How to get shownext to just shownext once (1997) Webcat deletes last line from Excel-saved text db (2004) Re:Running 2 two WebCatalog.acgi's (1996) [WebDNA] [WSC] WebDNA Development Summit (2014) Error: Can't open order file. Ignoring [OrderFile] context (2000) lookup problem (2000) Not really WebCat (1997) Ship Cost Calculated via Subtotal (1998) [WebDNA] Setting up a new server, hierarchy question (2014) Close-to Comparison Code (1998) FW: Shipping calculations (1997) Setting up WebCatalog with Retail Pro data (1996) SKU lookup (1997) Re(2): MASTER_STORE revision (2002) Possible Bug in 2.0b15.acgi (1997)