RE: Nested [SEARCH] and [REPLACE] problem.

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 13082
interpreted = N
texte = Michael ->I'm trying to write an admin page that let's me update inventory quantities>without shutting down my web server. To do this, I>1) Flush databases>2) Replace the quantities in the OLD database with quantities from a NEW>database>and>3) Flush database so that the changes are not just in RAM in case something>crashes.>Steps 1 and 3 are easy, but step 2 doesn't seem to work so well. Here's>the code that I'm using. I can't find anything wrong with it:>[SEARCH db=DB/NEW_Inventory.db&neskudata=0]>[FOUNDITEMS]> [Replace db=DB/OLD_Inventory.db&neSKUdata=0]> QTY=[QTY]&Append=T> [/Replace]>[/FOUNDITEMS]>[/SEARCH]>What am I doing wrong? Is there a better way to do it?After playing around a bit, I think I see a couple of things wrong with this. First off, make sure your replace values come immediately after the opening [replace] context, like[Replace db=DB/OLD_Inventory.db&neSKUdata=0]QTY=[QTY]&Append=T[/Replace]so it's not looking for a field name like ' QTY' instead of 'QTY'Next, for the replace command, you'll want to match the record found in the new database, with eqSKUdata=[SKU], instead of neSKUdata=0, otherwise all records with a SKU not equal to zero will be replaced with the same quantity for as many found items as you have, and eventually all of them will have the same quantity as the last item found in the new database.I'm not totally sure if that last part makes any sense or not, but try using something like this:[SEARCH db=DB/NEW_Inventory.db&neskudata=0][FOUNDITEMS] [Replace db=DB/OLD_Inventory.db&eqSKUdata=[SKU]]QTY=[QTY]&Append=T[/Replace][/FOUNDITEMS][/SEARCH]and you should be okay.I hope this helps,Marc EagleStarNine Technologieshttp://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

RE: Nested [SEARCH] and [REPLACE] problem. (Marc Eagle 1997)

Michael ->I'm trying to write an admin page that let's me update inventory quantities>without shutting down my web server. To do this, I>1) Flush databases>2) Replace the quantities in the OLD database with quantities from a NEW>database>and>3) Flush database so that the changes are not just in RAM in case something>crashes.>Steps 1 and 3 are easy, but step 2 doesn't seem to work so well. Here's>the code that I'm using. I can't find anything wrong with it:>[SEARCH db=DB/NEW_Inventory.db&neskudata=0]>[founditems]> [Replace db=DB/OLD_Inventory.db&neSKUdata=0]> QTY=[QTY]&Append=T> [/Replace]>[/FOUNDITEMS]>[/SEARCH]>What am I doing wrong? Is there a better way to do it?After playing around a bit, I think I see a couple of things wrong with this. First off, make sure your replace values come immediately after the opening [replace] context, like[Replace db=DB/OLD_Inventory.db&neSKUdata=0]QTY=[QTY]&Append=T[/Replace]so it's not looking for a field name like ' QTY' instead of 'QTY'Next, for the replace command, you'll want to match the record found in the new database, with eqSKUdata=[SKU], instead of neSKUdata=0, otherwise all records with a SKU not equal to zero will be replaced with the same quantity for as many found items as you have, and eventually all of them will have the same quantity as the last item found in the new database.I'm not totally sure if that last part makes any sense or not, but try using something like this:[SEARCH db=DB/NEW_Inventory.db&neskudata=0][founditems] [Replace db=DB/OLD_Inventory.db&eqSKUdata=[SKU]]QTY=[QTY]&Append=T[/Replace][/FOUNDITEMS][/SEARCH]and you should be okay.I hope this helps,Marc EagleStarNine Technologieshttp://www.smithmicro.com/ Marc Eagle

DOWNLOAD WEBDNA NOW!

RE: Nested [SEARCH] and [REPLACE] problem.

1997

Top Articles:

Related Readings: