Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23311
interpreted = N
texte = Thank You.Actually that is the way I was doing. I was calculating the price on-the-fly. It's just that It'll be easy for me having all the prices updated in my database, since I have a lot of another webdna code generating files to shopper, pricescan, killerapp, etc.So I figured out why to spend webcat time when I can do this faster with access or FileMaker. And so I did. I'm using an Access Query that updates my whole 100000 database in 2 minutes.PCS Technical Support wrote:> >[search db=..\Data\Partfull.db&neVend_PartData=[blank]] > >[founditems] > >[Replace db=..\Data\Partfull.db&eqVend_PartData=[Vend_Part]]Price=[format > >6.2f][math]([price]*1.03)[/math][/format][/Replace] > >[/founditems] > >[/search] > > > >But it take more than one hour to update the whole database running on a > >NT/Dual > >400-II Mhz. I was wondering if there is a fastest way to accomplish this. > > That's probably the fastest you can do that exact operation. But perhaps > an alternative approach would be better: why not just calculate the new > price on-the-fly whenever you need it on your site? Don't ever change the > database; just use your calculation on templates where the new price needs > to be displayed, and perhaps in your formulas.db when adding to the cart. > > Technical Support | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thank You.Actually that is the way I was doing. I was calculating the price on-the-fly. It's just that It'll be easy for me having all the prices updated in my database, since I have a lot of another webdna code generating files to shopper, pricescan, killerapp, etc.So I figured out why to spend webcat time when I can do this faster with access or FileMaker. And so I did. I'm using an Access Query that updates my whole 100000 database in 2 minutes.PCS Technical Support wrote:> >[search db=..\Data\Partfull.db&neVend_PartData=[blank]] > >
[founditems] > >[Replace db=..\Data\Partfull.db&eqVend_PartData=[Vend_Part]]Price=[format > >6.2f]
[math]([price]*1.03)[/math][/format][/Replace] > >[/founditems] > >[/search] > > > >But it take more than one hour to update the whole database running on a > >NT/Dual > >400-II Mhz. I was wondering if there is a fastest way to accomplish this. > > That's probably the fastest you can do that exact operation. But perhaps > an alternative approach would be better: why not just calculate the new > price on-the-fly whenever you need it on your site? Don't ever change the > database; just use your calculation on templates where the new price needs > to be displayed, and perhaps in your
formulas.db when adding to the cart. > > Technical Support | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Carlos Machado
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:
date pref (1999)
HTML encoding in URLs (1997)
[WebDNA] Issue with including functions (2011)
Signal Raised Error (Part II) (1997)
NT vs Mac (1997)
Online reference (1997)
How can I Add several Items into the cart at once? (1997)
Date problems (1997)
Order not created error (1997)
Who owns the code? (2002)
Replace context (1998)
WebCatalog NT beta 18 problem (1997)
[include] (1998)
Placement of .tpl files? (2000)
Listfiles context (2000)
[OT] Linux Mailservers (2003)
problems with 2 tags shakur (1997)
Exclamation point (1997)
[CART] (1997)
Last freebie (1998)