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.scOn 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:
Just wrote it out with the returns to make it easier to read for now.scOn 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)