Re: Realtime Top 10

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23788
interpreted = N
texte = [replace db=sales.db&eqskudata=[sku]]count=[math][lookup db=sales.db&lookinfield=sku&value=[sku]&returnfield=count]+[qty][/math][/rep lace]This just takes the value count and makes it equal to the count in the db + the number in the quantity field.You will probably need to do this in the context of an orderfile or the lineitems of the thankyou page so that each item is increased by the quantity added.---------- >From: Arthur Frischman >To: >Subject: Realtime Top 10 >Date: Tue, Feb 16, 1999, 11:54 AM >> I am trying to create a real time Top 10 Sales List. > > I have a separate database called sales.db to maintain the units sales. > > I think, after the customer hits purchase and it goes to a thank you page I > need to pull us the prior sales from that product, add one and update the > database. The database would be part of a search on the front page based on > sales units. Associated Messages, from the most recent to the oldest:

    
  1. Re: Realtime Top 10 (Bob Minor 1999)
  2. Realtime Top 10 (Arthur Frischman 1999)
[replace db=sales.db&eqskudata=[sku]]count=[math][lookup db=sales.db&lookinfield=sku&value=[sku]&returnfield=count]+[qty][/math][/rep lace]This just takes the value count and makes it equal to the count in the db + the number in the quantity field.You will probably need to do this in the context of an orderfile or the lineitems of the thankyou page so that each item is increased by the quantity added.---------- >From: Arthur Frischman >To: >Subject: Realtime Top 10 >Date: Tue, Feb 16, 1999, 11:54 AM >> I am trying to create a real time Top 10 Sales List. > > I have a separate database called sales.db to maintain the units sales. > > I think, after the customer hits purchase and it goes to a thank you page I > need to pull us the prior sales from that product, add one and update the > database. The database would be part of a search on the front page based on > sales units. Bob Minor

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:

[WebDNA] my spawned [purchase] seems to be losing the orderfile. ... [MOVEFILE] workaround? (2009) Need relative path explanation (1997) BUG?-.html extention not working. (2000) RE: creating writefile data from a nested search (1997) Locking up with WebCatalog... (1997) Online reference (1997) Sending Email (2004) Associative lookup style? (1997) WebCat editing, SiteGuard & SiteEdit (1997) Requiring that certain fields be completed (1997) Formatting time output (2000) Cart Number sequence (1997) Thanks ! (1997) Newbie from and old bee (1997) WebCat2.0 [format thousands .0f] no go (1997) [TaxableTotal] - not working with AOL and IE (1997) RE: Need Help (1998) RE: Error reading data -1 (1997) [decrypt seed=seed][getchars (1999) WebCat2b15MacPlugin - [protect] (1997)