Re: Price question
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21008
interpreted = N
texte = >I am trying to set the price for my items based on the customer account #>and am not having much success. The 2 approaches I have tried are:>1) Putting a [lookup] in my formulas.db, (when I use the lookup>elsewhere it returns the correct price). This returns a value of 0.00 each>time.>2) Putting the same [lookup] in the price field for each item. Again>returning a value of 0.00 each time.#1 above is the correct approach. If you are not getting the right value,it probably means the formula does not 'know' what the value of yourcustomer# is at the time the formula is being calculated. This means youneed to pass the customer# in as an extra parameter to the command=Add, orperhaps set one of the header1-40 fields in the order file to the customer#so you can use it later in your formula like [header5].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 am trying to set the price for my items based on the customer account #>and am not having much success. The 2 approaches I have tried are:>1) Putting a
[lookup] in my
formulas.db, (when I use the lookup>elsewhere it returns the correct price). This returns a value of 0.00 each>time.>2) Putting the same
[lookup] in the price field for each item. Again>returning a value of 0.00 each time.#1 above is the correct approach. If you are not getting the right value,it probably means the formula does not 'know' what the value of yourcustomer# is at the time the formula is being calculated. This means youneed to pass the customer# in as an extra parameter to the command=Add, orperhaps set one of the header1-40 fields in the
order file to the customer#so you can use it later in your formula like [header5].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:
is sku a REQUIRED field on NT (1997)
Webcatalog 4.0 - When will we be able to beta test it? (2000)
Search (1997)
WebMerchant 1.6 and SHTML (1997)
The last version of webcat (1999)
set header in DB (no cart) (2003)
notification solutions (1997)
[referrer] tag (1997)
Running _every_ page through WebCat ? (1997)
cart file creation (2003)
[WebDNA] [OT] ImageMagick or similar (2015)
WebCatalog for Postcards ? (1997)
WC1.6 to WC2 date formatting (1997)
Using Checkbox (2000)
Shopping with Accounts (2003)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Unit Cost Look Up (2001)
Aaron kant add (or whatever it was) (2000)
japanese characters (1997)
RE: Append problem w/" (1999)