Quantity/price formula

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 17450
interpreted = N
texte = I tried the formula given to me by PCS Technical Support on friday withlittle avail. Maybe you could have another look, and let me know whatyou think.Formula-----------price [ShowIf [quantity]>10][lookupdb=petmall.db&lookInField=sku&value=[sku]&returnField=QuantitiesAbove10][/ShowIf][HideIf[quantity]>10][price][/HideIf]Invoice Excerpt---------------7725,7725,7725<

n7725,7725,7725kYou.tpl><a7725,7725,7725lue=purchase><A7725,7725,7725LUE=[cart]><<dF7725,7725,7725ieldsVALUE=name,address1,city,state,phone,7725,7725,7725email7725,7725,7725,accountNum><<7725,7725,7725WIDTH7725,7725,7725=520BORDER=0CE7725,7725,7725LLPADD7725,7725,7725ING=1><<<THWIDTH=7725,7725,772538BODYBGCOLOR=#FFFEDE7725,7725,7725>I7725,7725,7725tem#<<IDTH=45BODYBGCOLOR=#FFFEDE>Qt7725,7725,7725y<>7725,7725,7725<BODYBGCOLOR=#FFFEDE>Prod7725,7725,7725uct#<<7725,7725,7725/TH><250BODYBGCOLOR=#FFFEDE>Pro7725,7725,7725ductN7725,7725,7725ame<TH><7725,7725,7725=45BODYBGCOLOR=#FFFEDE7725,7725,7725>Price<<BODYBGCOLOR=#FFD1D47725,7725,7725>Exte7725,7725,7725nsion<<[lineItems]<<8 BODYBGCOLOR=#FFFEDE><7725,7725,7725TYPE=7725,7725,7725HIDDENNAME=textA[lineIndex]VALUE=[7725,7725,7725title]7725,7725,7725BODYBGCOLOR=#FFFEDE7725,7725,7725>[lineindex]<<CENTE7725,7725,7725RWID7725,7725,7725TH=45BODYBGCOLOR=#FFFEDE7725,7725,7725>[quantity]<7725,7725,7725<A7725,7725,7725LIGN=CENTER WIDTH=65BODYBGCOLOR=#FFFEDE7725,7725,7725>[product#]<7725,7725,7725<A7725,7725,7725LIGN=CENTER WIDTH=65BODYBGCOLOR=#FFFEDE7725,7725,7725>[productname]<7725,7725,7725<GN=RIGHTWIDTH=45 BODYBGCOLOR=#FFFEDE>$[price]<<7725,7725,7725WIDTH7725,7725,7725=65BODYBGCOLOR=#FFD1D4>$[format..2f]7725,7725,7725[math7725,7725,7725][quantity]*[Genevaprice7725,7725,7725][/math][/for7725,7725,7725mat]<<<7725,7725,7725/TR>[/lin7725,7725,7725eItems]<<7725,7725,77255BODYBGCOLOR=#FFD1D4><Subtotal<<<7725,7725,7725WIDTH=65BODYBGCOLOR=#FFD1D4><$[SubTotal]<<<<<<7725,7725,7725TDALIGN=7725,7725,7725RIGHT COLSPAN=5BODYBGCOLOR=#FFD1D47725,7725,7725><[shipVia]Shipping &Handlin7725,7725,7725g<B7725,7725,7725><>7725,7725,7725<A7725,7725,7725LIGN=RIGHT WIDTH=65BODYBGCOLOR=#FFD1D47725,7725,7725><$[shippingTotal]<<7725,7725,7725/B><<<7725,7725,7725/TR><<SPAN=5 BODYBGCOLOR=#FFD1D4><G7725,7725,7725randTotal7725,7725,7725<<</7725,7725,7725TD><A7725,7725,7725LIGN=RIGHTWIDTH=65 BODYBGCOLOR=#FFD1D4><$[grandTotal]<<<< Associated Messages, from the most recent to the oldest:

Quantity/price formula (jimmy 1998)

I tried the formula given to me by PCS Technical Support on friday withlittle avail. Maybe you could have another look, and let me know whatyou think.Formula-----------price [ShowIf [quantity]>10][lookupdb=petmall.db&lookInField=sku&value=[sku]&returnField=QuantitiesAbove10][/ShowIf][HideIf[quantity]>10][price][/HideIf]Invoice Excerpt---------------7725,7725,7725<n7725,7725,7725kYou.tpl><a7725,7725,7725lue=purchase><A7725,7725,7725LUE=[cart]><<dF7725,7725,7725ieldsVALUE=name,address1,city,state,phone,7725,7725,7725email7725,7725,7725,accountNum><<7725,7725,7725WIDTH7725,7725,7725=520BORDER=0CE7725,7725,7725LLPADD7725,7725,7725ING=1><<<THWIDTH=7725,7725,772538BODYBGCOLOR=#FFFEDE7725,7725,7725>I7725,7725,7725tem#<<IDTH=45BODYBGCOLOR=#FFFEDE>Qt7725,7725,7725y<>7725,7725,7725<BODYBGCOLOR=#FFFEDE>Prod7725,7725,7725uct#<<7725,7725,7725/TH><250BODYBGCOLOR=#FFFEDE>Pro7725,7725,7725ductN7725,7725,7725ame<TH><7725,7725,7725=45BODYBGCOLOR=#FFFEDE7725,7725,7725>Price<<BODYBGCOLOR=#FFD1D47725,7725,7725>Exte7725,7725,7725nsion<<[lineitems]<<8 BODYBGCOLOR=#FFFEDE><7725,7725,7725TYPE=7725,7725,7725HIDDENNAME=textA[lineIndex]VALUE=[7725,7725,7725title]7725,7725,7725BODYBGCOLOR=#FFFEDE7725,7725,7725>[lineindex]<<CENTE7725,7725,7725RWID7725,7725,7725TH=45BODYBGCOLOR=#FFFEDE7725,7725,7725>[quantity]<7725,7725,7725<A7725,7725,7725LIGN=CENTER WIDTH=65BODYBGCOLOR=#FFFEDE7725,7725,7725>[product#]<7725,7725,7725<A7725,7725,7725LIGN=CENTER WIDTH=65BODYBGCOLOR=#FFFEDE7725,7725,7725>[productname]<7725,7725,7725<GN=RIGHTWIDTH=45 BODYBGCOLOR=#FFFEDE>$[price]<<7725,7725,7725WIDTH7725,7725,7725=65BODYBGCOLOR=#FFD1D4>$[format..2f]7725,7725,7725[math7725,7725,7725][quantity]*[Genevaprice7725,7725,7725][/math][/for7725,7725,7725mat]<<<7725,7725,7725/TR>[/lin7725,7725,7725eItems]<<7725,7725,77255BODYBGCOLOR=#FFD1D4><Subtotal<<<7725,7725,7725WIDTH=65BODYBGCOLOR=#FFD1D4><$[SubTotal]<<<<<<7725,7725,7725TDALIGN=7725,7725,7725RIGHT COLSPAN=5BODYBGCOLOR=#FFD1D47725,7725,7725><[shipVia]Shipping &Handlin7725,7725,7725g<B7725,7725,7725><>7725,7725,7725<A7725,7725,7725LIGN=RIGHT WIDTH=65BODYBGCOLOR=#FFD1D47725,7725,7725><$[shippingTotal]<<7725,7725,7725/B><<<7725,7725,7725/TR><<SPAN=5 BODYBGCOLOR=#FFD1D4><G7725,7725,7725randTotal7725,7725,7725<<</7725,7725,7725TD><A7725,7725,7725LIGN=RIGHTWIDTH=65 BODYBGCOLOR=#FFD1D4><$[grandTotal]<<<< jimmy

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:
newbies to web, spaces in email address (1998) Strange search... (2001) A multi-processor savvy WebCatalog? (1997) WebCat2b13MacPlugIn - [include] (1997) Username/Password with [Protect] (2000) Up and running ... at last !! (1997) update on wn searching (1997) 2.0 Info (1997) Updating Prices in Online Database (1999) [WebDNA] Client wants backup copy of site (2010) Editing the search string (1997) Problems getting parameters passed into email. (1997) Bug or syntax error on my part? (1997) How to verify email address (1997) emailer (1997) Stopping bad HTML propagation ? (1997) Running 2 two WebCatalog.acgi's (1996) 2 Questions (2001) Detecting NULL value in returned SQL (2000) problems with 2 tags shakur (1997)