This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
November 14, 2011 12:56pm
Subscribe [2]#1 / Nov 14, 2011 12:56pm
Hey,
I’m using jQRangeSlider so users can pick a price range (based on my price custom field), entries will then be filtered when I click the submit button based on the prices.
I can get a single value (say like 9000) to work by using Dynamo but how would I do a price range search (say from 1000 to 2000) using SQL queries?
Many thanks,
Ka-Chun
#2 / Nov 14, 2011 8:33pm
You may want to look at http://www.solspace.com/docs/detail/super_search_search/ Super Search which will allow you to provide a to and from value for custom fields. Alternatively there is always the query module if you are handy with SQL.
#3 / Nov 15, 2011 4:39am
Sure that sounds goods but I want to try it out in SQL queries first and if that doesn’t work I can resort to using Super Search.