RE: pricing continued

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21097
interpreted = N
texte = Yes, since this isn't in production yet, I have one of my forms set to always flush the databases. Also, the price line in the formulas.db is not the last line. I modified the tearoom formulas.db, and have made sure that there is a at the end of the line. Could the problem be that I modify the file on a PC and then ftp it over to a MAC? -----Original Message----- From: PCS Technical Support [SMTP:support2@smithmicro.com] Sent: Tuesday, November 17, 1998 4:09 PM To: WebDNA-Talk@smithmicro.com Subject: Re: pricing continued >I'm still trying to get Webcatalog to provide me with pricing based on the >customer ID, and I think that I have it narrowed down to not finding my >formulas.db for some reason. For example, when I place the code: >[lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] >in my results.tpl, it displays the price I want. However, when I set my >formulas.db as follows I get 0.00 returned for the price in my cart.tpl: >price [lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] After you modified the Formulas.db, did you tell WebCatalog to flush its databases so it can reload the new one from disk? And is there are carriage return after the end of the line...WebCatalog can't see the last line of a database if the last byte of the file is not a carriage return. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. RE: pricing continued (Puchalski, Steve 1998)
  2. RE: pricing continued (PCS Technical Support 1998)
  3. RE: pricing continued (Puchalski, Steve 1998)
  4. Re: pricing continued (PCS Technical Support 1998)
Yes, since this isn't in production yet, I have one of my forms set to always flush the databases. Also, the price line in the formulas.db is not the last line. I modified the tearoom formulas.db, and have made sure that there is a at the end of the line. Could the problem be that I modify the file on a PC and then ftp it over to a MAC? -----Original Message----- From: PCS Technical Support [SMTP:support2@smithmicro.com] Sent: Tuesday, November 17, 1998 4:09 PM To: WebDNA-Talk@smithmicro.com Subject: Re: pricing continued >I'm still trying to get Webcatalog to provide me with pricing based on the >customer ID, and I think that I have it narrowed down to not finding my >formulas.db for some reason. For example, when I place the code: >[lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] >in my results.tpl, it displays the price I want. However, when I set my >formulas.db as follows I get 0.00 returned for the price in my cart.tpl: >price [lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] After you modified the formulas.db, did you tell WebCatalog to flush its databases so it can reload the new one from disk? And is there are carriage return after the end of the line...WebCatalog can't see the last line of a database if the last byte of the file is not a carriage return. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Puchalski, Steve

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:

Creating comums (1998) Any way to retrieve information from clipboard? (1998) WebCat2b12--[searchstring] bug (1997) All choices on IE different than Netscape (1997) Error Msg (1997) setting cookies for another domain? (2002) History of beta changes? (1999) Custom buttons using site builder (2005) Hosting Services (1999) shipcost (1997) Order not created error (never mind) (1997) default image if image in code not available (2003) PCS Emailer's role ? (1997) # fields limited? (1997) WebCatalog 3.0.8 Mac OS (2000) WebCat2 - [SendNews] (1997) what's wrong with this picture (2006) WebCatalog/Mac 2.1b2 - PIXO (1997) Was code to phantom spacing -- now BBEdit [!][/!] (2001) Meet your competition (2000)