Re: Prices coming up 0.00

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40003
interpreted = N
texte = Here is my line in the formulas db: price [lookup db=inventory/inventory.db&lookInField=sku&value=[sku]&returnField=price]I'm still getting zeros and I checked all your suggestions.-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Peacock Sent: Thursday, November 08, 2001 2:51 PM To: WebCatalog Talk Subject: Re: Prices coming up 0.00 Stephen Russo wrote: > > I am in a [search] [founditems] context when displaying [price] on the pages > it shows. > I am adding items to the cart using a [command=add] in the a href link. >You meanhttp://yourserver.com/xx.tpl?command=Add&db=SomeDatabase.db&sku=1234&cart=56 78&quantity=5right?So the issue is back to square one. Clearly the database you are searching has a field price so it is displaying when you are in a [founditems] context. But the page after the command=add is not displaying the price, so therefore your formulas.db is messed up. Can I assume that you have made sure that the template and the formulas.db are in the same directory?Post the price line from the formulas.db. Place an order and then open up the cart file and show us the contents.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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://search.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Prices coming up 0.00 (Velma Kahn 2001)
  2. Re: Prices coming up 0.00 (John Peacock 2001)
  3. Re: Prices coming up 0.00 (Stephen Russo 2001)
  4. Re: Prices coming up 0.00 (John Peacock 2001)
  5. Re: Prices coming up 0.00 (Glenn Busbin 2001)
  6. Re: Prices coming up 0.00 (John Peacock 2001)
  7. Re: Prices coming up 0.00 (Glenn Busbin 2001)
  8. Re: Prices coming up 0.00 (John Peacock 2001)
  9. Re: Prices coming up 0.00 (Stephen Russo 2001)
  10. Re: Prices coming up 0.00 (John Peacock 2001)
  11. Re: Prices coming up 0.00 (John Peacock 2001)
  12. Re: Prices coming up 0.00 (John Peacock 2001)
  13. Re: Prices coming up 0.00 (Glenn Busbin 2001)
  14. Re: Prices coming up 0.00 (Stephen Russo 2001)
  15. Re: Prices coming up 0.00 (Stephen Russo 2001)
  16. Re: Prices coming up 0.00 (John Peacock 2001)
  17. Re: Prices coming up 0.00 (Donovan Brooke 2001)
  18. Prices coming up 0.00 (Stephen Russo 2001)
Here is my line in the formulas db: price [lookup db=inventory/inventory.db&lookInField=sku&value=[sku]&returnField=price]I'm still getting zeros and I checked all your suggestions.-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Peacock Sent: Thursday, November 08, 2001 2:51 PM To: WebCatalog Talk Subject: Re: Prices coming up 0.00 Stephen Russo wrote: > > I am in a [search] [founditems] context when displaying [price] on the pages > it shows. > I am adding items to the cart using a [command=add] in the a href link. >You meanhttp://yourserver.com/xx.tpl?command=Add&db=SomeDatabase.db&sku=1234&cart=56 78&quantity=5right?So the issue is back to square one. Clearly the database you are searching has a field price so it is displaying when you are in a [founditems] context. But the page after the command=add is not displaying the price, so therefore your formulas.db is messed up. Can I assume that you have made sure that the template and the formulas.db are in the same directory?Post the price line from the formulas.db. Place an order and then open up the cart file and show us the contents.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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://search.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://search.smithmicro.com/ Stephen Russo

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:

RED QUESTION MARK (1999) Where is f2? (1997) HTML Editors (1997) Comments in db? (1997) Re:trouble (1997) Price (2000) WebSTAR plugin update (2004) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) WebMerchant 1.6 and SHTML (1997) [WriteFile] problems (1997) Multiple Ad databases? (1997) Caching [include] files ... (1997) WebCat2 several catalogs? (1997) [WebDNA] hide [DOS] command strings on resulting page (2016) Nesting format tags (1997) Summing fields (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) CSS in HTML emails? (2003) FYI: virus alert (1996) Attn: Bug in GeneralStore example b15 (1997)