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:

sorting problem for sku=0? (1998) No incentive ... (2000) Emailer (1997) Applescript in Webcatalog problem (1997) Generating unique SKU from [cart] (1997) Before I Can Begin . . . (1998) Header values are not accepted (1998) suffix mapping, use of cache, etc. (1997) [WebDNA] WebSite Examples (2008) User/pass with tcpconnect (2000) line endings for Mac OS X files? (2003) CORR: date format (2000) Keep away (1997) RE: Server Traffic Simulation (1998) Searching for (field1 OR field2) AND field3 (2000) RE: [WebDNA] smtp authentication (2008) A quickie question (1997) [group] ? (1997) Hosting (2000) Loss in Form (1998)