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 to true or false, and use the formulas.db to specify price. I'd build the database with both prices for the album (say, TapePrice and CDPrice), and then perform a [lookup] in the formulas.db, based on which variable was true (Tape or CD), like this:Name FormulaPrice [showif [tape]=T][lookup db=catalog.db&value=[sku]&lookinfield=sku&returnfield=TapePrice][/showif][showif [CD]=T][lookup db=catalog.db&value=[sku]&lookinfield=sku&returnfield=CDPrice][/showif]That way, the price they see when they look at their cart or the final order 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. Winningham System Administrator, Database Programmer, Web Catalog Designer WebWright Inc. -- The Internet Commerce Company john@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 to true or false, and use the
formulas.db to specify price. I'd build the database with both prices for the album (say, TapePrice and CDPrice), and then perform a
[lookup] in the
formulas.db, based on which variable was true (Tape or CD), like this:Name FormulaPrice [showif [tape]=T][lookup db=catalog.db&value=[sku]&lookinfield=sku&returnfield=TapePrice][/showif][showif [CD]=T][lookup db=catalog.db&value=[sku]&lookinfield=sku&returnfield=CDPrice][/showif]That way, the price they see when they look at their cart or the final order 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. Winningham System Administrator, Database Programmer, Web Catalog Designer WebWright Inc. -- The Internet Commerce Company john@webwrightinc.com
John S. Winningham
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:
Searching multiple Databases (1997)
Bad creator codes which cause access denied errormessage (1997)
Add a field to the error log? (1997)
In Digest Dijon (2000)
Hiding a subsection of text (2002)
[WebDNA] Help with STMP Setup using Authentication with Google (2016)
about this server and links to who (1997)
Non-Cart Files in Shopping Cart Folder (1997)
PCS Emailer's role ? (1997)
Thanks Grant (1997)
Re:Dumb Question about Docs (1997)
Need help with emailer- 2 issues (1997)
NetForms for mail, sorry (1998)
strange IE 4.0 (1998)
Converting SQL Microtime to Date and Time (2003)
WebCatalog Plugin: Getting Data Canceled (2000)
America Online Issues (1998)
Looking for a Manual (1997)
Database Locking?!? (2000)
Need relative path explanation (1997)