I know first step check the forum and resources
then try yourself. In this case it did not help
me too much. I found that there are two
functions for search with name-gt=value or
name=>value in the query but I must have
misunderstood something. I have a field Price.
It should not be but it is definded as varchar.
There are numbers in the format xxx.xx nothing else. If I do a search in a with price=<23 or 23.00 I get results with 101.94, 15.27 but not 23.96.
This seems a little strang to me but I do not know what´s wrong.

Thanks

Niko

Hi,

You need to change the column type. You can't do this in the admin unfortunately as it doesn't support floats (should though). You need to run:

ALTER TABLE Links CHANGE Price Price FLOAT

where Links is the table name (may be prefixed), and Price is the column name (yes it's meant to be there twice).

Then do a resync tables and you should be fine.

Cheers,

Alex
--
Gossamer Threads Inc.

thank you very much for both answers.