Re: [ic] Numeric Search

[Mark Bryant <suppressed>]

At 16:30 14/06/2005, you wrote:
> Hi,
>
> I can't seem to figure out how to get this numeric search to work. I have
> products priced at 0.00 and I want to create a search that will not display
> them. So I tried this:
> scan/fi=products/st=db/co=1/sf=suggested_retail/se=0.00/op=>/nu=1/ml=50.html
>
> No luck. I was hoping someone knows a way around this.
>
> Thanks,
> Brian
>
> _______________________________________________
> interchange-users mailing list
> suppressed
> http://www.icdevgroup.org/mailman/listinfo/interchange-users


Hi Brian,

Assuming you have a suggested_retail field/col to search on in your DB, 
change the > to gt in the line to get that to work :)

scan/fi=products/st=db/co=1/sf=suggested_retail/se=0.00/op=gt/nu=1/ml=50.html

Failing that try setting sf=price if your pricing info is stored there. 
Worked for me when I tried it a few mins ago although it doesn't seem to 
take into account TAX settings/values.

Mark



Eros Shop
vwe internet ltd
PO BOX 1067
SLOUGH
SL1 7YA
UK

Shop - http://www.eros-shop.co.uk
EMail - suppressed
Tel - 0870 284 3369
Fax - 0870 284 4469


_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users