Re: Formulas.db not working
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66165
interpreted = N
texte = Hi Charles. I will specify a couple of things.. hope they don't appear to obvious, but sometimes obvious things are overlooked. 1.) I usually [url][/url] most any [sku] fields. 2.) Is there a CR after the last record? 3.) Are your permissions the same on that .db as the other.db's? Donovan Charles Kline wrote: > Hi all. > > Been a really long time since I used Formulas.db for anything. Anyhow, > I am trying to setup a discount on 1 item in the catalog. I have a very > simple formula: > > price
[showif [sku]=12345][lookup > db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/showif] > > Anyhow.. this is not working (does not return any change in price). > Even if I change my formula to just return a hard coded value such as > 999 I get no change in price. > > The file is in the directory with the rest of the templates and is > named Formulas.db > > Mac OS X Sever 10.3 - Apache - WebDNA v. 6.x > > Thanks for any assistance. > > - Charles > > -- > RightCode, Inc. > 900 Briggs Road #130 > Mount Laurel, NJ 08054 > P: 856.608.7908 > F: 856.439.0154 > E: ckline@rightcode.net -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Charles. I will specify a couple of things.. hope they don't appear to obvious, but sometimes obvious things are overlooked. 1.) I usually [url][/url] most any [sku] fields. 2.) Is there a CR after the last record? 3.) Are your permissions the same on that .db as the other.db's? Donovan Charles Kline wrote: > Hi all. > > Been a really long time since I used formulas.db for anything. Anyhow, > I am trying to setup a discount on 1 item in the catalog. I have a very > simple formula: > > price[showif [sku]=12345][lookup > db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/showif] > > Anyhow.. this is not working (does not return any change in price). > Even if I change my formula to just return a hard coded value such as > 999 I get no change in price. > > The file is in the directory with the rest of the templates and is > named formulas.db > > Mac OS X Sever 10.3 - Apache - WebDNA v. 6.x > > Thanks for any assistance. > > - Charles > > -- > RightCode, Inc. > 900 Briggs Road #130 > Mount Laurel, NJ 08054 > P: 856.608.7908 > F: 856.439.0154 > E: ckline@rightcode.net -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/
Donovan Brooke
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:
Simple Database close connection (2001)
[WebDNA] .html extension (2012)
Bulk Email Limits (2001)
File Upload Problems (HELP!) (2000)
credit card authorization question (1997)
still having shipCost.db Problem (1997)
Lost Records in Database (2001)
Interesting speed comparison .. (2003)
[OT] search engine Q (2001)
Trouble with formula.db (1997)
Bug Report, maybe (1997)
Need formum software... (2003)
WebCat2b13MacPlugIn - [include] (1997)
redirect with frames (1997)
form validator issue (2005)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
[OT] (waaaay OT) (2004)
PSC recommends what date format yr 2000??? (1997)
Javascript and Search Results (1998)
Problems with [Search] param - Mac Plugin b15 (1997)