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:
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:
Search in 2 or more catalogs (1997)
WebCat2 several catalogs? (1997)
WebCat2b12--[searchstring] bug (1997)
Area codes? (2001)
Error Log (2000)
Showif, Hideif reverse logic ? (1997)
Generating unique SKU from [cart] (1997)
Hairy Shipping Monster (2006)
Great product and great job ! (1997)
What am I missing (1997)
RE: ANother SHOWIF problem (1997)
MacOS 9 => ODBC=> Ms SQL Server 7 (2000)
[OT] Appropriate Signature??? (2003)
The IBC root beer has arrived! (1997)
WebCatalog Prefs.ref file ? (1998)
Sorting by date (1997)
syntax for contains a word (2002)
Searching Numbers (2004)
Zeroing out shipping costs (2000)
3RD POST Character limit in [Search]? (1998)