Merry Christmas to the whole mailing list and your families :)
Artur Reilin
sqlite.yuedream.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Quoth Joe Bennett , on 2010-12-24 18:28:18 -0600:
> Have a question regarding a particular issue I am dealing with... I
> have a database in which I create a pivot table to get a no dupe list
> using a 'select distinct'. I then take that list into Python and then
> iterate over it to look up data i
On 25 Dec 2010, at 12:28am, Joe Bennett wrote:
> update_data = 'update matrix set %s = %f, %s = %f where %s = "%s"' %
> (A_B + '_Lat', Lat_Site, A_B + '_Lon',Lon_Site, A_B, Site[0])
You've used double quotes. I'm guessing that the value is a string, in which
case you mean single quotes. But t
Hi all,
Have a question regarding a particular issue I am dealing with... I
have a database in which I create a pivot table to get a no dupe list
using a 'select distinct'. I then take that list into Python and then
iterate over it to look up data in another table to add in the
latitude and longit
On Fri, Dec 24, 2010 at 5:19 PM, Andrew Z wrote:
> My application accesses an SQLite database created by another
> application, and I noticed on my system (SQLite 3.7.2, Fedora 14) if
> the subquery returns no values, the delete clause does nothing. Is
> this a bug in SQLite?
No. SQLite is gi
Hi,
SQLite sounds pretty reasonnable to me:
>select "select distinct favicon_id from moz_places";
>select distinct favicon_id from moz_places;
Returns NULL
>select "deleting: standard method...";
>delete from moz_favicons where id not in (select distinct favicon_id
>from moz_places); -- here i
My application accesses an SQLite database created by another
application, and I noticed on my system (SQLite 3.7.2, Fedora 14) if
the subquery returns no values, the delete clause does nothing. Is
this a bug in SQLite? The expected result below is that all rows from
moz_favicons are deleted.
C
Hi,
I recently discovered that for vfs implemented writable formats that
actually change the data of the sqlite base (encryption, compression), there
should be a complex logic behind the restoration from the hot journal, at
least some versions ago. For correct password handling initially I relied
> Select
>H1.ID
> from
>HASH1 H1
> where
>x1_y1 BETWEEN min11 AND max11 AND
>x1_y2 BETWEEN min12 AND max12 AND
>x1_y3 BETWEEN min13 AND max13 AND
>x1_y4 BETWEEN min14 AND max14 AND
>x1_y5 BETWEEN min15 AND max15;
>
>
no it's not work at all !! without an rtree index th
i do it.. but it's change nothing :(
On 12/24/2010 3:47 PM, Simon Slavin wrote:
> On 24 Dec 2010, at 8:17am, Vander Clock Stephane wrote:
>
>> I have a key like this
>>
>> 123-098-230-120-111 where (123), (098), (230), (120), (111) are what i
>> call node
>> Node are integer comprise between 0 and
On 24 Dec 2010, at 12:47pm, Simon Slavin wrote:
> Precalculate five sets of minimum and maximum bounds:
>
> min11 = max((<#randomnumber> % 255)-10,0)
> max11 = min((<#randomnumber> % 255)+10,255)
>
> Then you can just seize the ten values you need from the table and use them
> to make up you
On 24 Dec 2010, at 8:17am, Vander Clock Stephane wrote:
> I have a key like this
>
> 123-098-230-120-111 where (123), (098), (230), (120), (111) are what i
> call node
> Node are integer comprise between 0 and 255 (bytes)
You mean from 000 to 254. 255 breaks your system because you are using
can you gave me the name of a good SSD you advise me to buy ?
i decide to make a try !
Thanks again
stéphane
On 12/24/2010 12:24 AM, John Drescher wrote:
> On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane
> wrote:
>> that very very much expensive :( how much you thing ?
>>
> $500 to $600
> Can you describe what you're trying to do with that command ?
of course !
I have a key like this
123-098-230-120-111 where (123), (098), (230), (120), (111) are what i
call node
Node are integer comprise between 0 and 255 (bytes)
and i need to found "similare" key.
A similar key is a key wh
14 matches
Mail list logo