Re: Formulas.db not working
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66168
interpreted = N
texte = Hi Donovan, On Feb 3, 2006, at 11:47 AM, Donovan Brooke wrote: > > 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? I have now taken this process down to basics. There is only one item in the db and it has a SKU of 12345. There is a CR after the last record Permissions on this db are the same as all. Really not sure what else to try. - Charles > > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ -- RightCode, Inc. 900 Briggs Road #130 Mount Laurel, NJ 08054 P: 856.608.7908 F: 856.439.0154 E: ckline@rightcode.net ------------------------------------------------------------- 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 Donovan, On Feb 3, 2006, at 11:47 AM, Donovan Brooke wrote: > > 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? I have now taken this process down to basics. There is only one item in the db and it has a SKU of 12345. There is a CR after the last record Permissions on this db are the same as all. Really not sure what else to try. - Charles > > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ -- RightCode, Inc. 900 Briggs Road #130 Mount Laurel, NJ 08054 P: 856.608.7908 F: 856.439.0154 E: ckline@rightcode.net ------------------------------------------------------------- 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/
Charles Kline
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:
WebCat2 - many [carts] on one template page? (1997)
[WebDNA] Feature requests - date format (2009)
Use of Back and Reload Buttons on ShoppingCart page? (1997)
MySQL Wildcard Trouble (2006)
Multiple SSL Keys (1998)
[WebDNA] New request for websites that currently run WebDNA (2009)
WebCat2: multiple currency support (1997)
RE: [WebDNA] TCPconnect and Bitcoin rate (2017)
Bug? (1997)
Seeking Better Display of results... (1997)
Kill the webcat process (2000)
MySQL (2003)
Show items based on login Password (2003)
Authenticate Questions (2003)
Sort Order on a page search (1997)
WebCatalog for Dummies part 2 (2000)
WebSite and *NO* Authentication Dialog Box!!? (1998)
WebCatb15 Mac CGI -- [purchase] (1997)
newbie question about zip code search (2003)
WebCat2 beta 11 - new prefs ... (1997)