[Typo3-shop] Work method

Bill Alexy bill at psiberware.com
Tue Nov 1 21:10:37 CET 2005


> This is where the
>   10.where =
> Settings in pricecalc are intended for, This settings defines for which 
> records the field-comparison shall take place.
> Here you can set a SQL where clause when this will be programmed in much 
> less than 22 hours.
> 
> 
> Franz

So this is what I have thus far, but my where condition isn't working. I 
still get the values returned for 10.prod rather than 20.prod where= 
gradings=White Mid-Gloss Perm

plugin.tt_products.pricecalc {
   10.type = count
   10.field = price
   10.where =
   10.prod.1 = .11
   10.prod.100 = 10.95
   10.prod.250 = 24.95
   10.prod.500 = 47.95
   10.prod.1000 = 79.95
   10.prod.2000 = 155.90
   10.prod.3000 = 233.85
   10.prod.4000 = 311.80
   10.prod.5000 = 374.75
   10.prod.6000 = 449.70
   10.prod.7000 = 524.65
   10.prod.8000 = 599.60
   10.prod.9000 = 674.55
   10.prod.10000 = 739.50
   10.prod.11000 = 813.45
   10.prod.12000 = 887.40
   10.prod.13000 = 961.35
   10.prod.14000 = 1035.30
   10.prod.15000 = 1109.25
   10.prod.16000 = 1183.20
   10.prod.17000 = 1257.15
   10.prod.18000 = 1331.10
   10.prod.19000 = 1405.05
   10.prod.20000 = 1399.00
   10.prod.21000 = 1468.95
   10.prod.22000 = 1538.90
   10.prod.23000 = 1608.85
   10.prod.24000 = 1678.80
   10.prod.25000 = 1748.75

   20.type = count
   20.field = price
   20.where = gradings=White Mid-Gloss Perm
   20.prod.1 = .10
   20.prod.100 = 999.99

where am I going wrong? I'm so close to doing this right I can taste it.

Best regards,
Bill



More information about the TYPO3-project-tt-products mailing list