Can any1 help.. my range search is not quite right..

If I search for 700,001-1,200,000... it does not display past 999,999.. so some results do not get displayed..

when the price is entered into the database.. it goes in with commas.. everything else works.. just not over this figure..

Im sure its because there is two commas now and not one if its under 1,000,000

Any Ideas.. thanxs in advance... Justin.

********************

<SELECT NAME="Price">
<OPTION value="*">All Prices in Euros
<OPTION value="10,000-100,000">Upto - 100,000
<OPTION value="100,000-150,000">100,000 - 150,000
<OPTION value="150,000-200,000">150,000 - 200,000
<OPTION value="200,000-250,000">200,000 - 250,000
<OPTION value="250,000-300,000">250,000 - 300,000
<OPTION value="300,000-350,000">300,000 - 350,000
<OPTION value="350,000-400,000">350,000 - 400,000
<OPTION value="400,000-500,000">400,000 - 500,000
<OPTION value="500,000-600,000">500,000 - 600,000
<OPTION value="600,000-700,000">600,000 - 700,000
<OPTION value="700,000-1,200,000">700,000 - 1,200,000</SELECT>

*********************

My Field_Type is numer

*********************

local (%sortby);

if ($in{'Price'}) {
unless ($in{'Price'} eq "*") {
($in{'Price-gt'},$in{'Price-lt'}) = split (/-/,$in{'Price'});
$in{'Price'} = '';
}
}

Check out this thread:

Thread: http://gossamer-threads.com/p/000511
Topic: search by range?
cvsiv - July 13, 1999

Or visit the FAQ noted below under the section "Search" for the thread titled "Price Range Search".

These will provide the codes to eliminate the commas within the price which should solve your problem.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Thanxs for the help.. jpdeni had the solution i needed.. appreciated.. Justin