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
My educated guess is, interval column has a string value '0' in this row, not a
nume
Since I have blobs, datetimes, and integers I managed to use the
hex-convertion on some integers as well. They are stored as text in my
program.
I changed the code for the interval integer, so it is inserted as an
integer. It seems to work. I don't get this strange kind of selection
anymore.
Than
Patrik Nilsson wrote:
After dumping the database I found that the line of insertion looks like
this
INSERT INTO "repetition"
VALUES(617,X'323031322D31322D32332031393A33303A3436',X'30',X'323031322D31322D32332031393A33303A3436',0,1,1,0);
Does SQLite manage the insertion with hexadecimal character
On 23 Dec 2012, at 8:42pm, Patrik Nilsson wrote:
> After dumping the database I found that the line of insertion looks like
> this
>
> INSERT INTO "repetition"
> VALUES(617,X'323031322D31322D32332031393A33303A3436',X'30',X'323031322D31322D32332031393A33303A3436',0,1,1,0);
>
> Does SQLite manag
On Sun, Dec 23, 2012 at 2:51 PM, Patrik Nilsson
wrote:
> Hi All!
>
> 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
>
What does this say:
select *, typeof
After dumping the database I found that the line of insertion looks like
this
INSERT INTO "repetition"
VALUES(617,X'323031322D31322D32332031393A33303A3436',X'30',X'323031322D31322D32332031393A33303A3436',0,1,1,0);
Does SQLite manage the insertion with hexadecimal characters?
On 12/23/2012 09:19
Patrik Nilsson wrote:
> 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 s
> 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
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
Hi All!
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
10 matches
Mail list logo