Re: More help for discount pricing

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19093
interpreted = N
texte = At 15:44 Uhr 24.07.1998, Jerry Nielsen wrote:>Here's a very truncated version of the database. > >SKU SHDESC PRLVL01 PRLVL02 PRLVL03 QTYLVL01 QTYLVL02 QTYLVL03 >BN-5418P Blue 20 19 18 11 23 49 > >BP-5915NL Black 19 18 17.5 11 23 49 >BP-5215NL Red 19 18 17.5 11 23 49>[showif [quantity[lineindex]]>[lookup >db=Catalog.txt&lookinfield=sku&value=[sku]&returnfield=QTYLVL01]] >[PRLVL02][/showif]For a lineindex of 2 this means in your database example: if [quantity2] is greater 11 than take $18 And it will take $18 for ANY number of items above 11. It will never switch to PRLVL03 Is that the problem? Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21 Associated Messages, from the most recent to the oldest:

    
  1. Re: More help for discount pricing (Jerry Nielsen 1998)
  2. Re: More help for discount pricing (Peter Ostry 1998)
  3. More help for discount pricing (Jerry Nielsen 1998)
At 15:44 Uhr 24.07.1998, Jerry Nielsen wrote:>Here's a very truncated version of the database. > >SKU SHDESC PRLVL01 PRLVL02 PRLVL03 QTYLVL01 QTYLVL02 QTYLVL03 >BN-5418P Blue 20 19 18 11 23 49 > >BP-5915NL Black 19 18 17.5 11 23 49 >BP-5215NL Red 19 18 17.5 11 23 49>[showif [quantity[lineindex]]>[lookup >db=Catalog.txt&lookinfield=sku&value=[sku]&returnfield=QTYLVL01]] >[PRLVL02][/showif]For a lineindex of 2 this means in your database example: if [quantity2] is greater 11 than take $18 And it will take $18 for ANY number of items above 11. It will never switch to PRLVL03 Is that the problem? Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21 Peter Ostry

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:

Wanted: More Math Functions (or, Can You Solve This?) (1997) Re:Adding non-SKUs to cart (1998) Width & Height (1998) Bug Report, maybe (1997) SKU (1997) Shopping with Accounts (2003) Million product store (2003) Printing controls - form feeds (2002) Webcat/Webmerchant (1998) forms (2001) Remove Command not working (2000) Is the Finder required? (1998) list items (1998) Loops N Variables (1998) Max Record length (1997) [WebDNA] Help needed with some weird crashes (2010) Shell and telnet (2002) WARNING: deletedb anomaly (2002) creator code (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997)