Re: More help for discount pricing

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19095
interpreted = N
texte = >>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 Thanks for the reply, Peter.Actually, that's sort of the problem. I knew that would happen. I tried to figure out how to use [hideIf] to limit the value returned, but I couldn't get it to work.I guess it's fair to say I'm having trouble with both the logic and the WebDNA.I haven't been able to get past this and have anything show up in the returned template.JerryJerry N. Nielsen Voice: (310)264-2050 Apple Computer, Inc. Fax: (310)264-2044 Training Development Executive Cellular: (626)695-2895 2041 Colorado Avenue - Suite 325 Santa Monica, CA 90404Learn about Apple products and technologies on the internet. Sign up for Learn and Earn today at http://training.apple.com/lae/ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 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)
>>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 Thanks for the reply, Peter.Actually, that's sort of the problem. I knew that would happen. I tried to figure out how to use [hideif] to limit the value returned, but I couldn't get it to work.I guess it's fair to say I'm having trouble with both the logic and the WebDNA.I haven't been able to get past this and have anything show up in the returned template.JerryJerry N. Nielsen Voice: (310)264-2050 Apple Computer, Inc. Fax: (310)264-2044 Training Development Executive Cellular: (626)695-2895 2041 Colorado Avenue - Suite 325 Santa Monica, CA 90404Learn about Apple products and technologies on the internet. Sign up for Learn and Earn today at http://training.apple.com/lae/ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Jerry Nielsen

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:

SV: [sendmail] (2000) why is authenticate screwing with me today (2002) how realize an advertiser ? (2005) [foundItems] context question --returns some fields but not others-- (2000) slowness (1998) emailer (1997) [blank] (2005) Multiple Sendmail Tags on One Page (2008) Adding discount to cart (2000) RE: Upload (1998) [Announce]: Web server security and password protection (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) PCS Emailer's role ? (1997) SAVECART (1997) Location of Browser Info.txt file (1997) [createfolder] & [deletefolder] (1997) WebCatalog can't find database (1997) Separate SSL Server (1997) searchable list archive (1997) WebCatalog NT beta 18 now available (1997)