Re: Updating Prices db (still not working)
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23486
interpreted = N
texte = The only thing I can think of is that the SKUs in the newcatalog.db don't match any of the SKUs in the catalog.db. The [numFound] indicates the number of SKUs found in the newcatalog.db, not the actual number of records replaced.Mike Eberly wrote: > > 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 -- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * WWW: http://www.altimac.com * **************************************************************
Associated Messages, from the most recent to the oldest:
The only thing I can think of is that the SKUs in the newcatalog.db don't match any of the SKUs in the catalog.db. The [numFound] indicates the number of SKUs found in the newcatalog.db, not the actual number of records replaced.Mike Eberly wrote: > > 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 -- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * WWW: http://www.altimac.com * **************************************************************
Gil Poulsen
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:
raw field names (2001)
PSC recommends what date format yr 2000??? (1997)
Credit Card not accepted (1998)
webcatalog [date] bug...not (1999)
[username][password] not showing up! HELP! (1999)
Prevent multiple appends with Reload Button (1997)
Append (1999)
WebCat2 - [format thousands] (1997)
Installing WebDNA on Linux (2007)
How to display images? (2002)
[WebDNA] Wrong email address (2008)
WebCat2 - [include] tags (1997)
OLD ORDERS (1998)
Simple way to create unique SKU (1997)
emailer settings and control questions (1997)
Not really WebCat (1997)
WEBCAT HIERARCHY (1999)
emailer truncates last letter! (1997)
[shell] wget (2004)
WebCat editing, SiteGuard & SiteEdit (1997)