Hey Gray,
so if the value is rounded you indeed need to store it as string instead of
double. To get around your search problem when you do so, what you are running
into is limitation of JCR SQL. The cast of string to double can be used only on
the right hand side of the expression (yeah, i know, go figure :D ). Since you
are entering one of the values directly, make sure you enter that as a number
straightaway and use right hand side case for value stored as string.
So instead of
[code]
select * from [mgnl] where CAST(myDoubeProperty as Double) > CAST('100.0' as
Double)
[/code]
try something like:
[code]
select * from [mgnl] where 100.0 <= CAST(myDoubeProperty as Double)
[/code]
HTH,
Jan
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=fb6148c5-9687-45db-9f07-8570c9a8c364
----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
