Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23281
interpreted = N
texte = >[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:
>[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/
PCS Technical Support
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:
A better WebCat whois (was [OT] Domain Name Scam) (2000)
Calculating Shipping (1997)
[WebDNA] [OT] Apple iPad (2010)
Interesting speed comparison .. (2003)
[/application] error? (1997)
Email Mac (2002)
[SQL] & ODBC on Mac - Reposted (2000)
[shownext max=?] armed (1997)
Can't Update records (1997)
WebCat2: Master Counter snippet (1997)
How can I Add several Items into the cart at once? (1997)
ReturnRaw and redirect one last question (1997)
5.0 feature request: (2001)
emptying shopping carts and orders folder (2004)
searchable list archive (1997)
[closeDataBase myDataBase.db] not working? (1997)
I give up!! (1997)
Test (2006)
Multiple download orders of the same product? (1997)
SiteGuard Admin Feature ? (1997)