Re: multiple price line in formula.db

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56322
interpreted = N
texte = Just wrote it out with the returns to make it easier to read for now. sc On Monday, February 23, 2004, at 03:27 PM, Donovan Brooke wrote: > Steve Chun wrote: >> Having problems with getting one price for retail and one price for >> wholesale customers. I have two different price fields and the >> following in the formula.db for the price line. >> [if cust=wholesale >> [then][lookup >> db=inventory.db&lookInField=SKU&value=[SKU]&returnField=wprice] >> [/then] >> [else] >> [lookup >> db=inventory.db&lookInField=SKU&value=[SKU]&returnField=rprice] >> [/else] >> [/if] >> Should I be using the [showif] instead? >> sc > > > Hi Steve, > the formulas.db can not have returns in it. > > you can comment out your returns like: > > [if ..][!] > [/!][then][!] > [/!][/then][!] > [/!][else][!] > [/!][/else][!] > [/!][/if] > > You should also encase the sku value in an URL. > [url][sku][/url] > > Donovan > > > > -- > =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 Eucalyptus Design > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > N2862 Summerville Park Rd. > Lodi, WI 53555 > PH:> 1.608.592.3567 > Web:> 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/ > ------------------------------------------------------------- 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:

    
  1. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  2. Re: multiple price line in formula.db ( Gary Krockover 2004)
  3. Re: multiple price line in formula.db ( Steve Chun 2004)
  4. Re: multiple price line in formula.db ( Tim Robinson 2004)
  5. Re: multiple price line in formula.db ( Gary Krockover 2004)
  6. Re: multiple price line in formula.db ( Tim Robinson 2004)
  7. Re: multiple price line in formula.db ( Steve Chun 2004)
  8. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  9. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  10. Re: multiple price line in formula.db ( Tim Robinson 2004)
  11. Re: multiple price line in formula.db ( Steve Chun 2004)
  12. Re: multiple price line in formula.db ( Tim Robinson 2004)
  13. Re: multiple price line in formula.db ( Steve Chun 2004)
  14. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  15. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  16. multiple price line in formula.db ( Steve Chun 2004)
Just wrote it out with the returns to make it easier to read for now. sc On Monday, February 23, 2004, at 03:27 PM, Donovan Brooke wrote: > Steve Chun wrote: >> Having problems with getting one price for retail and one price for >> wholesale customers. I have two different price fields and the >> following in the formula.db for the price line. >> [if cust=wholesale >> [then][lookup >> db=inventory.db&lookInField=SKU&value=[SKU]&returnField=wprice] >> [/then] >> [else] >> [lookup >> db=inventory.db&lookInField=SKU&value=[SKU]&returnField=rprice] >> [/else] >> [/if] >> Should I be using the [showif] instead? >> sc > > > Hi Steve, > the formulas.db can not have returns in it. > > you can comment out your returns like: > > [if ..][!] > [/!][then][!] > [/!][/then][!] > [/!][else][!] > [/!][/else][!] > [/!][/if] > > You should also encase the sku value in an URL. > [url][sku][/url] > > Donovan > > > > -- > =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 Eucalyptus Design > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > N2862 Summerville Park Rd. > Lodi, WI 53555 > PH:> 1.608.592.3567 > Web:> 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/ > ------------------------------------------------------------- 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/ Steve Chun

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:

SKU lookup (1997) Conveting Characters to Graphics (1997) Progress !! WAS: Trouble with formula.db (1997) b12 cannot limit records returned and more. (1997) RE: Questions To Answer (1997) Removing [showif] makes a big difference in speed (1997) adding up in a db (1997) Confirmation emails classified as junk (2000) URGENT! Locked DB's (2001) WebCatb15 Mac CGI -- [purchase] (1997) MOOOOOO (2000) WebCat2b12 CGI Mac - [shownext] problem (1997) Practice runs ? (1997) Web Catalog Instability (2000) Search results templates (1996) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Can webcat 3.0/4.0 handle 1,000,000 hits a day? (2000) ups quickcost [repost] (1999) Problems with upload / WebCat (1998) Searching multiple Databases (1997)