Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Using numbers with decimals

Quote Reply
Using numbers with decimals
Using the real estate template, if I change the bathroom qty field to use decimal places to accomodate 1/2 baths (ex. 1.5 baths), the listings with anything to the right of the decimal will not show up in search results. It will only search whole numbers. How do I make it search the whole numbers as well as the decimals?
Quote Reply
Re: [BrianC] Using numbers with decimals In reply to
Can anyone answer this please?
Quote Reply
Re: [BrianC] Using numbers with decimals In reply to
In this case, the data type should be FLOAT

TheStone.

B.
Quote Reply
Re: [TheStone] Using numbers with decimals In reply to
works :)



many thanks!
Quote Reply
Re: [BrianC] Using numbers with decimals In reply to
Hi Guys,

I tried FLOAT but it didn't work for me as I'd expected, however I found DECIMAL did the trick.

Just thought I'd add this to the thread for future reference.

All the best
Shaun