Selecting Floating point numbers: Summary

2002-02-11 Thread Miguel Figueiredo
Hello again, In reply to all the suggestions made, here it goes one more mail. I hope it will be helpful. (André, isto vai em ingles que é para o pessoal perceber ;) Suggestion 1: Float aren't really searchable in Mysql. You may need to do some casting, not sure how to do it on top but i

Problems with select

2002-02-08 Thread Miguel Figueiredo
Hello all, I have a (probably dumb) question. My table temperatura has two fields described bellow. mysql describe temperatura; +-+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra |

Selecting Floating point numbers: Summary

2002-02-08 Thread Miguel Figueiredo
Hello again, In reply to all the suggestions made, here it goes one more mail. I hope it will be helpful. (André, isto vai em ingles que é para o pessoal perceber ;) Suggestion 1: Float aren't really searchable in Mysql. You may need to do some casting, not sure how to do it on top but i