Re: pricing continued
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21093
interpreted = N
texte = >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 itsdatabases so it can reload the new one from disk? And is there arecarriage return after the end of the line...WebCatalog can't see the lastline 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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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 itsdatabases so it can reload the new one from disk? And is there arecarriage return after the end of the line...WebCatalog can't see the lastline 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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Formvariables + Netscape + Frame Set = Confusion (2000)
Cold Fusion Buster (1997)
SSL do I need it?? (1998)
[WebDNA] unsubscribe (2008)
[convertChars] and HTML Tags (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Using [Include] Context (1999)
search problem (2002)
[WebDNA] Anyone submitted SoAP info in TCPSEND? (2017)
WebCatalog can't find database (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
[ot] ShowIf & HideIf Question (1998)
protect tag on NT IIS (1997)
WebDNA install - linux (permissions rehash?) (2002)
Re[2]: Using the sendmail command on CGate Pro (Unix) (2000)
database with 10,000+ web pages stored in it? (2000)
Mime Headers for Mail (1998)
[WebDNA] Converting | to TAB (2010)
Contain in search (2005)
Updating shipcost (2005)