I think this is not really sqlite related, i am using fastcgi with nginx
server and when security became in issue i had similar problems
quick solution - do 'chmod -R 777 /srv/www' and you will see if problem
is related to rights or if its something else
also i think you should use absolute
i had similar problems and it was caused by microsoft office
it didn't used ordinary dash but some strange character with different
ascii code - so search based on it always failed
i had to convert these strange dashes to ordinary ones to make it work
try, maybe this is also your case
On 17. 3. 2010 11:49, Mike Martin wrote:
> sample time= 2010-03-16 23:06:00
> sample start= 2010-03-16-22:00:00
> sample end= 2010-03-16 23:05:00
> select tsid from recordings where '2010-03-16 23:05:00' between start and end'
>
> This query should return nothing, so can anyone explain why it is
i somehow skipped one message in thread and as result i posted you what you
already knew and wrote, sorry no more ideas from me
On 25. 1. 2010 12:27, greensparker wrote:
>
> Thnks michel for ur reply.
> yes thats the way. i also tried using the HANDLE. but the query failed in
> int b =
i did it, and solution is not nice
in general, qt doesn't export any of sqlitefunctions in its sqlite driver. so
you have to add sqlite to your project. you can find version of sqlite used in
qt in its sources (qt/src/3rdparty/sqlite) or if its set to use dynamically
sqlite installed in system you
just an idea - make sure you are crosscompiling and libsqlite3.a is for
arm-linux and not for cygwin
j.hermanussen wrote:
> Hi to all, I'm new on this list.
>
> I'm working on an application that runs on a small ARM-LINUX device, too
> small to contain GCC. So I've installed Cygwin on my Win XP
itwise operators cannot be changed so easily to inequalities.
>
i didn't said this condition should be *replaced* , i said that inequality
should be *added*. then index could limit resultset, but bitwise operator will
still be used, only on hopefully smaller set of data
>
> Pavel
>
&
Daniel Wickes wrote:
> I'm trying to optimise some of my queries, and I would like to know if
> bitwise operators in terms will still use an index, or if I should be
> thinking about moving the more important values to separate columns that
> could be checked for equality.
>
> At the moment, I
Atul_Vaidya wrote:
> Hi,
> How to store a multimap in SQlite database ?
> My requirement is that i want to store a multimap in a column of
> the SQlite table
> Regards,
> Atul
i don't use stl but i also work with more complex structures.
the best approach to save them in database is
MADHAVAN VINOD wrote:
>
> 5) No INDEX created.
>
> The retrieval logic is such that to retrieve the oldest 10 records along
> with some additional constraints (say a, b and c are columns and the
> constraints are like a=1 AND b < c).
>
>
>
> So my WHERE clause is like "CurrTime <=
for me sqlite is database engine. and its files i call databases
CadMapper wrote:
> This is not a technical question about SQLite. I want to you how people in
> general think about SQLite. Is that a file or a database? When you talk
> about it, do you refer to it as file or database?
>
>
hi
attached is patch which will make temporary disable of triggers possible. i
tried it in my application with current data (many inserts in to various table
with many triggers on them, which are not meant to be run while importing data).
it works and it changed running time from 62 seconds to 4,
hi
attached is patch which will make temporary disable of triggers possible. i
tried it in my application with current data (many inserts in to various table
with many triggers on them, which are not meant to be run while importing data).
it works and it changed running time from 62 seconds to 4,
Robert Citek wrote:
> create table foo (
> col_1, col_2, col_3, col_4, col_5, col_6, col_7, col_8, col_9,
> col_10, col_11, col_12, col_13, col_14, col_15, col_16, col_17,
> col_18, col_19, col_20, col_21, col_22 ) ;
> .mode tab
> .imp "foo.tsv" "foo"
> select col_9, col_22, count(*) as
D. Richard Hipp wrote:
> On Jun 24, 2009, at 10:35 AM, Michal Seliga wrote:
>>> Instead of
>>>
>>> WHEN not exists(SELECT * FROM )
>>>
>>> create an application-defined function (perhaps called
>>> "enable_triggers()&quo
D. Richard Hipp wrote:
> On Jun 24, 2009, at 9:17 AM, Michal Seliga wrote:
>
>> hi
>>
>> in my application i sometimes must insert huge amount of pre-
>> prepared data so i
>> don't want triggers to do any action while i am inserting them
>>
>>
hi
in my application i sometimes must insert huge amount of pre-prepared data so i
don't want triggers to do any action while i am inserting them
for this reason i created one small table which is normally empty, however if it
contains record set to 1 triggers shoudl not do any action. to make
17 matches
Mail list logo