Re: Multiple prices per product
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58096
interpreted = N
texte = No worries. The usual arrangement... small unmarked bills... I know what it's like to pull your hair out for hours, and then a fresh pair of eyes sees the answer in two seconds. I'm glad I'm on the other side of it this time! Regards, Tim > From: Gary Krockover
> Reply-To: (WebDNA Talk) > Date: Fri, 28 May 2004 01:15:42 -0500 > To: (WebDNA Talk) > Subject: Re: Multiple prices per product > > 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/ ------------------------------------------------------------- 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:
No worries. The usual arrangement... small unmarked bills... I know what it's like to pull your hair out for hours, and then a fresh pair of eyes sees the answer in two seconds. I'm glad I'm on the other side of it this time! Regards, Tim > From: Gary Krockover > Reply-To: (WebDNA Talk) > Date: Fri, 28 May 2004 01:15:42 -0500 > To: (WebDNA Talk) > Subject: Re: Multiple prices per product > > 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/ ------------------------------------------------------------- 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/
Tim Robinson
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:
Date Time Oddness (1999)
completed orders database (1997)
Test! (2003)
Re:ListFields and [name] (1997)
2.01 upgrade problems (1997)
Unix Webcat Permission - Suggestions (2000)
Associative lookup style? + bit more (1997)
MATH TIME (1997)
date sorting and 'template (1997)
Looking for easy way to back up dbs... (2003)
Saving [referrer] for later use (1997)
show all problem (1997)
RE: type 2 errors with ssl server (1997)
[WebDNA] naming math vars in v.7 (2010)
[OT] ssh user@domain.com (2004)
WebCatalog can't find database (1997)
strip .0 off off IPaddress (1998)
Extended [ConvertChars] (1997)
One more time (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)