Re: Multiple prices per product

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58094
interpreted = N
texte = You sir, are a stinkin' genius! As simple as that and it took care of a days worth of frustrations. Much appreciated! GK At 12:45 AM 5/28/2004, you wrote: >What does your formula entry look like? > >I assume you'll have to set one of the lineitem text variables with the name >of the size chosen eg textA=size2, and then use that value to do a lookup >for the price in the formulas.db. > >Something like this maybe: >Name Formula >price [lookup db=products.db&lookInField=sku&value=[sku]&returnField= >price[GetChars start=1&end=1&from=end][textA][/GetChars]] > >Regards, >Tim ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Multiple prices per product ( Gary Krockover 2004)
  2. Re: Multiple prices per product ( Gary Krockover 2004)
  3. Re: Multiple prices per product ( Gary Krockover 2004)
  4. Re: Multiple prices per product ( Tim Robinson 2004)
  5. Re: Multiple prices per product ( Gary Krockover 2004)
  6. Re: Multiple prices per product ( Tim Robinson 2004)
  7. Re: Multiple prices per product ( Stuart Tremain 2004)
  8. Re: Multiple prices per product ( Gary Krockover 2004)
  9. Re: Multiple prices per product ( Tim Robinson 2004)
  10. Multiple prices per product ( Gary Krockover 2004)
You sir, are a stinkin' genius! As simple as that and it took care of a days worth of frustrations. Much appreciated! GK At 12:45 AM 5/28/2004, you wrote: >What does your formula entry look like? > >I assume you'll have to set one of the lineitem text variables with the name >of the size chosen eg textA=size2, and then use that value to do a lookup >for the price in the formulas.db. > >Something like this maybe: >Name Formula >price [lookup db=products.db&lookInField=sku&value=[sku]&returnField= >price[GetChars start=1&end=1&from=end][textA][/GetChars]] > >Regards, >Tim ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Gary Krockover

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:

Other tags inside the founditems context? (1998) possible bug in unix version? (2000) Pithy questions on webcommerce & siteedit (1997) WebCat2 - [format thousands] (1997) Not really WebCat - need HTML Grider (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Too Much In (1998) Need some feedback, please. (2003) Re2: frames & carts (1997) suffix mapping, use of cache, etc. (1997) form data submission gets truncated (1997) WebCat2 - storing unformatted date data? (1997) WebMerchant/PayFlowPro (2003) Wanted: More Math Functions (or, Can You Solve This?) (1997) Alternating BGColors in Table Rows (1998) Erotic Sites (1997) [lowercase] and [mixedcase] (1998) email list archive template (2004) Dynamically Generated Pages & WC? (2000) color (1999)