Re: [Price]

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14949
interpreted = N
texte = At 04:37 PM 11/20/97, you wrote: >>Under any page with a founditems context it will pull and show the [price] >>from the database, yet after I $add to the cart, then $showcart on next >>page using [lineitems] the price is not there. I checked all the code and >>it seems correct, plus I flushed my database when I uploaded the new one. > >When you $Add a product to the cart, WebCatalog looks in the formulas.db for a formula that defines the price. If you just remove that formula, it defaults to whatever [price] field is in your database (probably a good idea in your case). My guess is you used a formula that uses db=catalog.txt or something like that, and your actual database is named something else. > >The reason for the formulas is to give you more flexibility in pricing (certain customers get a discount, etc). The other reason is security -- rather that just look in a
for the price (which someone can hack easily), we require that price information come from server-side databases or formulas.That was it...Thank's Grant, I forgot I was using that. Associated Messages, from the most recent to the oldest:

    
  1. Re: [price] maddness (Andrew Simpson 2002)
  2. Re: [price] maddness (Arturo Vargas 2002)
  3. Re: [price] maddness (Donovan 2002)
  4. Re: [price] maddness (Arturo Vargas 2002)
  5. Re: [price] maddness (Donovan 2002)
  6. Re: [price] maddness (Arturo Vargas 2002)
  7. Re: [price] maddness (Arturo Vargas 2002)
  8. Re: [price] maddness (Gary Krockover 2002)
  9. Re: [price] maddness (Glenn Busbin 2002)
  10. Re: [price] maddness (John Peacock 2002)
  11. Re: [price] maddness (Glenn Busbin 2002)
  12. Re: [price] maddness (Donovan 2002)
  13. [price] maddness (Arturo Vargas 2002)
  14. Re: [price] via a search (PCS Technical Support 1998)
  15. [price] via a search (Marty Schmid 1998)
  16. Re: Display [price] in banner ad (PCS Technical Support 1998)
  17. Re: Display [price] in banner ad (Mark Bergkvist 1998)
  18. Re: Display [price] in banner ad (PCS Technical Support 1998)
  19. Re: Display [price] in banner ad (Mark Bergkvist 1998)
  20. Re: Display [price] in banner ad (PCS Technical Support 1998)
  21. Re: Display [price] in banner ad (Mark Bergkvist 1998)
  22. Re: Display [price] in banner ad (Kenneth Grome 1998)
  23. Display [price] in banner ad (Mark Bergkvist 1998)
  24. Re: [Price] (Raymond Hatch 1997)
  25. Re: [Price] (Raymond Hatch 1997)
  26. Re: [Price] (Grant Hulbert 1997)
  27. Re: [Price] (bob 1997)
  28. [Price] (Raymond Hatch 1997)
At 04:37 PM 11/20/97, you wrote: >>Under any page with a founditems context it will pull and show the [price] >>from the database, yet after I $add to the cart, then $showcart on next >>page using [lineitems] the price is not there. I checked all the code and >>it seems correct, plus I flushed my database when I uploaded the new one. > >When you $Add a product to the cart, WebCatalog looks in the formulas.db for a formula that defines the price. If you just remove that formula, it defaults to whatever [price] field is in your database (probably a good idea in your case). My guess is you used a formula that uses db=catalog.txt or something like that, and your actual database is named something else. > >The reason for the formulas is to give you more flexibility in pricing (certain customers get a discount, etc). The other reason is security -- rather that just look in a for the price (which someone can hack easily), we require that price information come from server-side databases or formulas.That was it...Thank's Grant, I forgot I was using that. Raymond Hatch

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:

Summing fields (1997) Database Field Additions (2000) price totals (2003) NT Version on IIS 4.0 (1997) Exclamation point (1997) mass mailing (1998) Emailer port change (1997) Associative lookup style? + bit more (1997) Proposed FormVariables hierarchy (2000) Sandbox Administation (2003) FEATURE REQUEST: Auto Resizing of images (2002) Am I going senile? (Price recalc based on quantity) (1997) counting characters and/or words (1997) [Cart] ... (1997) Fun with Dates - revisited (1997) WC 2.0 frames feature (1997) WebCat2b12--[searchstring] bug (1997) PCS Emailer's role ? (1997) Occasional crashes with $remove (1997) [WebDNA] Anyone interested .... (2011)