Re: Formulas.db not working
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66164
interpreted = N
texte = Been a while myself-Don't you have to do some math on the price, i.e.:price
[showif [sku]=12345][math][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/math][/showif]GaryAt 10:39 AM 2/3/2006, you 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.-------------------------------------------------------------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:
Been a while myself-Don't you have to do some math on the price, i.e.:price[showif [sku]=12345][math][lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/math][/showif]GaryAt 10:39 AM 2/3/2006, you 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.-------------------------------------------------------------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/
Gary Krockover
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:
Search crashing server (1998)
Banners (1997)
Emailer tracking (1997)
wierd [cart] action! (1997)
Using Cookie for client specific info? (1997)
Running _every_ page through WebCat ? (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)
WebCat b13 CGI -shownext- (1997)
WebTEN vs webSTAR (1998)
format search comparison Q (2000)
orders being printed (1998)
WebCatalog can't find database (1997)
WebCatalog for guestbook ? (1997)
Setting up shop (1997)
OT: BulkRegister.com (2002)
TCPconnect issue (2000)
test (2002)
Navigator 4.01 (1997)
PCS Frames (1997)
RequiredFields notes ... (1997)