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:
How can I Add several Items into the cart at once? (1997)
Order not created error (never mind) (1997)
Sku numbers (1997)
Text data with spaces in them... (1997)
[WebDNA] WebDNA vs. php war ;-) (2010)
WebCatb15 Mac CGI -- [purchase] (1997)
Search results templates (1996)
WebCatalog stalls (1998)
Field lenght (1998)
X Server (1999)
Re:no [search] with NT (1997)
email code (1998)
Multi Actions (1999)
Bug: MySQL WebDNA 6 int bigint fail case (2004)
problems with 2 tags shakur (1997)
cart number tracking (1998)
Question re: FlushDatabases (1997)
[WebDNA] WebDNA 7 (2011)
Max Record length restated as maybe bug (1997)
How To question on setting up downloads (1997)