> What do you get with query
> select * from repetition where cast(interval as integer)==0 and
> interval>0
"select * from repetition where cast(interval as integer)==0 and
interval>0 and id=617"
With this I get the same as the strange one. Without "id=617" it is
still selected.
/Patrik
On 12/23/2012 09:02 PM, Larry Brasfield wrote:
> Patrik Nilsson wrote:
>> When I perform a select as the following
>>
>> select * from repetition where interval>0 and id=617
>>
>> the result is unexpected
>>
>> 617|2012-12-23 19:30:46|0|2012-12-23 19:30:46|0|1|1|0
>>
>> It shows a result with "interval" zero, although I requested everything
>> above zero.
>>
>> When I select using the same statement and interval equal to zero, there
>> is no result lines.
>>
>> select * from repetition where interval=0 and id=617
>>
>> The table looks like:
>>
>> 0|id|integer|0||1
>> 1|last|datetime|1|datetime('now')|0
>> 2|interval|integer|0||0
>> 3|next|datetime|1|datetime('now')|0
>> 4|priority|integer|1|0|0
>> 5|repeat|integer|1|1|0
>> 6|valid|integer|1|0|0
>> 7|sound|integer|1|0|0
>
> What do you get with query
> select * from repetition where cast(interval as integer)==0 and
> interval>0
> ?
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
