Re: Multiply prices

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 13641
interpreted = N
texte = My thought would be to have a check box for CD or Tape price, set it totrue or false, and use the formulas.db to specify price. I'd build thedatabase with both prices for the album (say, TapePrice and CDPrice),and then perform a [lookup] in the formulas.db, based on which variablewas true (Tape or CD), like this:Name FormulaPrice [showif [tape]=T][lookupdb=catalog.db&value=[sku]&lookinfield=sku&returnfield=TapePrice][/showif][showif[CD]=T][lookupdb=catalog.db&value=[sku]&lookinfield=sku&returnfield=CDPrice][/showif]That way, the price they see when they look at their cart or the finalorder form will be that of the type of album they chose. JohnAllan Morrison wrote:> > I seting up a small gift shop and I need a little help with some WebDNA> (I'm far from an expert in it yet). My client is going to be putting some> tapes and CD's in the store and they DO NOT want to enter each album> twice. Once at the CD price, and once at the tape price. I suggested have> two catagories, one for tape and one for CD's, and that was shot down> before it got it out of my mouth. They want to display both prices and> have the person pick my check box or something which one they want. How> can i set it up so that they only have to enter something once with both> prices and the customer only sees the price of the iteam that they want> to buy?> > Allan Boy Wonder Morrison> WebMaster/Network Admin> Taisbean Multimedia> www.taisbean.com-- John S. WinninghamSystem Administrator, Database Programmer, Web Catalog DesignerWebWright Inc. -- The Internet Commerce Companyjohn@webwrightinc.com Associated Messages, from the most recent to the oldest:

Multiply prices (Allan Morrison 1997)
Re: Multiply prices (John S. Winningham 1997)

My thought would be to have a check box for CD or Tape price, set it totrue or false, and use the formulas.db to specify price. I'd build thedatabase with both prices for the album (say, TapePrice and CDPrice),and then perform a [lookup] in the formulas.db, based on which variablewas true (Tape or CD), like this:Name FormulaPrice [showif [tape]=T][lookupdb=catalog.db&value=[sku]&lookinfield=sku&returnfield=TapePrice][/showif][showif[CD]=T][lookupdb=catalog.db&value=[sku]&lookinfield=sku&returnfield=CDPrice][/showif]That way, the price they see when they look at their cart or the finalorder form will be that of the type of album they chose. JohnAllan Morrison wrote:> > I seting up a small gift shop and I need a little help with some WebDNA> (I'm far from an expert in it yet). My client is going to be putting some> tapes and CD's in the store and they DO NOT want to enter each album> twice. Once at the CD price, and once at the tape price. I suggested have> two catagories, one for tape and one for CD's, and that was shot down> before it got it out of my mouth. They want to display both prices and> have the person pick my check box or something which one they want. How> can i set it up so that they only have to enter something once with both> prices and the customer only sees the price of the iteam that they want> to buy?> > Allan Boy Wonder Morrison> WebMaster/Network Admin> Taisbean Multimedia> www.taisbean.com-- John S. WinninghamSystem Administrator, Database Programmer, Web Catalog DesignerWebWright Inc. -- The Internet Commerce Companyjohn@webwrightinc.com John S. Winningham

DOWNLOAD WEBDNA NOW!

Re: Multiply prices

1997

Top Articles:

Related Readings: