Re: Prices coming up 0.00
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40004
interpreted = N
texte = Stephen Russo wrote: > > Here is my line in the formulas db: > price [lookup > db=inventory/inventory.db&lookInField=sku&value=[sku]&returnField=price] > > I'm still getting zeros and I checked all your suggestions. > Change that to [lookup db=inventory/inventory.db&lookInField=sku&value=[sku]&returnField=price¬Found=SomethingWrong]and make sure you flush databases. This will show you that the [lookup] is at least firing. Are your SKU's just numbers/letters (i.e. no spaces)? You can use [url][sku][/sku] to be sure.You can also put that lookup on a page by itself and make sure that it is working (this is always the best way to test formulas). Are you sure that the inventory database is located in the correct place? I am not trying to solve your immediate problem as much as I am trying to show you how to solve your future problems.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Stephen Russo wrote: > > Here is my line in the formulas db: > price [lookup > db=inventory/inventory.db&lookInField=sku&value=[sku]&returnField=price] > > I'm still getting zeros and I checked all your suggestions. > Change that to [lookup db=inventory/inventory.db&lookInField=sku&value=[sku]&returnField=price¬Found=SomethingWrong]and make sure you flush databases. This will show you that the [lookup] is at least firing. Are your SKU's just numbers/letters (i.e. no spaces)? You can use [url][sku][/sku] to be sure.You can also put that lookup on a page by itself and make sure that it is working (this is always the best way to test formulas). Are you sure that the inventory database is located in the correct place? I am not trying to solve your immediate problem as much as I am trying to show you how to solve your future problems.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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://search.smithmicro.com/
John Peacock
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:
emailer setup (1997)
RE: Credit card processing - UK (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)
space (2002)
Fun with dates (1997)
Running _every_ page through WebCat ? (1997)
color and size options (1997)
bannerads example idiot (1997)
OT: Mobile Phone "mailto:" (2008)
searchable list archive (1997)
WebTen and WebCat (1997)
Why limit the length of a [math] variable name? (1999)
Search/sort in URL Was: GuestBook example (1997)
Encrypt/Decrypt (2007)
Running 2 two WebCatalog.acgi's (1996)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Mozilla/4. and Browser Info.txt (1997)
WebDNA equivalent for $REQUEST_URI (2004)
[WebDNA] Amazon EC2 (2009)
NT version (1997)