Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23398
interpreted = N
texte = Mike, in the fifth line of code, I think you have an extra bracket. Try:[Replace db=catalogtest.db]price=[price][/Replace]Also, I am assuming that both dbs have fields called sku and price.Mike Eberly wrote: > > I did a test to update my database by using the following code: > > [showif [dbpassword]=abcd] > [search db=newcatalog.db&neskudatarq=[blank]&max=8000] > [FoundItems] > [Replace db=catalogtest.db]price=[price]] [/Replace] > [/FoundItems] > [numFound] - records have been updated[/search] > [/showif] > [showif [dbpassword]!abcd] > Sorry, that password is not valid > [/showif] > > This did not replace the database with the new prices, like I had hoped > it would. I received no syntax error messages and 30 items were found, > yet the prices were not updated. Is there something I am missing in the > code? or am I doing something incorrectly? > Any ideas or suggestions would be of great help. > 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:
Mike, in the fifth line of code, I think you have an extra bracket. Try:[Replace db=catalogtest.db]price=[price][/Replace]Also, I am assuming that both dbs have fields called sku and price.Mike Eberly wrote: > > I did a test to update my database by using the following code: > > [showif [dbpassword]=abcd] > [search db=newcatalog.db&neskudatarq=[blank]&max=8000] >
[founditems] > [Replace db=catalogtest.db]price=[price]] [/Replace] > [/FoundItems] > [numFound] - records have been updated[/search] > [/showif] > [showif [dbpassword]!abcd] > Sorry, that password is not valid > [/showif] > > This did not replace the database with the new prices, like I had hoped > it would. I received no syntax error messages and 30 items were found, > yet the prices were not updated. Is there something I am missing in the > code? or am I doing something incorrectly? > Any ideas or suggestions would be of great help. > 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:
2.1 pricing? (1998)
WebCatalog for guestbook ? (1997)
Client-side Image Maps and WebCat? (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
How nuch ram??? (1997)
Re:Hideif / Showif (1998)
5.0 feature request: Sort for ListWords (2001)
All choices on IE different than Netscape (1997)
WebCatalog in the subject line for this list? (2000)
WebMerchant and Mac Auth Hub Help Please (1999)
Sorting by date (1997)
Emailer setup (1997)
Emailer (WebCat2) (1997)
Email notification to one of multiple vendors ? (1997)
Symantec VIsual Page 1.0.3 (1997)
Archives Suppor [was:Hyperlink in email] (2002)
Multi-processor Mac info ... (1997)
Drop down menu (2003)
The IBC root beer has arrived! (1997)
WebMerchant Problem... (1999)