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 pairof eyes sees the answer in two seconds. I'm glad I'm on the other side of itthis 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 pairof eyes sees the answer in two seconds. I'm glad I'm on the other side of itthis 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:
Re:Running 2 two WebCatalog.acgi's (1996)
Credit card types (1997)
[OT] (waaaay OT) (2004)
WebCat2 - [format thousands] (1997)
GuestBook example (1997)
RAM variables (1997)
Same DB Same Time (2004)
Opposite of Summ=T? (2000)
won't serve .tpl (2000)
[cart]= (2004)
Is there an easier way? (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
Fwd: more ! testing (1997)
WebCatalog Hosting (1996)
OT - Friday afternoon Fun with Toys (2002)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
WebCat Admin access w/ClearlyHome p.i. (1997)
Still Stumped on ShowNext...HELP! (1997)
4.5.1 on Panther? (2004)
Internet Explorer 6 Form problems (2005)