cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Query creation problem
Date Thu, 02 Jun 2011 11:36:18 GMT
I guess you may have to use SQLTemplate for this.

On May 31, 2011, at 5:26 PM, Wernke zur Borg wrote:

> Hi,
> 
> I need to create a query to select certain objects with a condition like so:
> 
>   SELECT*FROM tableWHERE(col/16)=10;
> 
> |where the expression (col / 16) must be computed using integer division.
> 
> Column 'col' is defined as integer but the expression (col / 16) yields a floating point
value, so the condition evaluates to false where it must not.
> 
> I tried using the expression parser with CAST and FLOOR operators but this is not supported.
> 
> |Any hints?
> 
> Thanks, Wernke
> 
> 
> 
> |
> |
> 
> 


Mime
View raw message