Re: Price spread
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44072
interpreted = N
texte = James, try:[search db=.db&eqPRODUCT_PICdatarq=[pic]&asPRICEsort=1&PRICEtype=num]
PIC | DESCRIPTION | PRICE | |
[founditems][showif [price]<180.01][showif [price]>99.99][pic] | [desctiption] | $[format.2f][PRICE][/format] | buy |
[/showif][/showif][/founditems][/search]if all you need is to show only those with a price of 100,140 or 180,us this in place of both those showif's:[showif _100_140_180_^_[price]_]Donovanyou can also do this in the search comparisons using group fields I believe.James Murtagh Jewellers wrote:> Hi there>> I am finishing a revamp on my site and would like help to provide the> customer with the spread of prices for products in the form>> Prices from $100 - $180>> ignoring each price between the lowest and the highest.>> The listing for a product is based on the photo code [pic], a> simplified example is below>> pic description price> cj131 10kt Gold Celtic Wedding Band $100> cj131 14kt Gold Celtic Wedding Band $140> cj131 18kt Gold Celtic Wedding Band $180>> I would be grateful for any help with this as I'm getting tight on time.>> JAMES MURTAGH>-------------------------------------------------------------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:
James, try:[search db=.db&eqPRODUCT_PICdatarq=[pic]&asPRICEsort=1&PRICEtype=num]PIC | DESCRIPTION | PRICE | |
[founditems][showif [price]<180.01][showif [price]>99.99][pic] | [desctiption] | $[format.2f][PRICE][/format] | buy |
[/showif][/showif][/founditems]