Would not adding verification cause a problem for those include the
downloading of sqlite in bash/make files of certain apps.
Lloydie T
- Original Message -
From: "Rich Shepard" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 30, 2007 2:50 PM
Subject: Re: [sqlite] Abuse of the SQLite
I wish to create a query where I do a number of counts on the same table but
with different filters.
ie:
count(id) as numrows
count(id) as inrows where direction = 'In'
count(id) as outrows where direction = 'Out'
Could I do the above in a single query?
| id | date | direction | dur
- Original Message -
From: "Rúben Lício" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, November 08, 2006 1:03 PM
Subject: [sqlite] PHP5 with SQLite3
Are you connecting correctly to the database. Which version of sqlite3 was
the database created in. I beleive php5.1 is version 3.2.8
Hi
I did try number literal >10 but mad no difference. I will rebuild the
database row as an integer.
Lloyd
- Original Message -
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite"
Sent: Thursday, October 26, 2006 12:21 AM
Subject: [sqlite] Re: numbe
I am using sqlite 3.2.8 which is included in PHP5.1. I seem to be having a
problem doing queries where with '>' to search a number.
for instance if I do the following
select ring_time fron calls where ring_time > '10';
I get the following results
3
6
3
6
3
6
2
3
3
3
2
etc.
Why?
This row is varc
Hi Lloyd,
I had exactly the same problem being new to C++. These are the
steps I took. You may find that the library files may be in a folder where
RH does not expect them to be. Try 'whereis libsqlite3.so' to locate. I
can't remember where the default lib folder is. you will need to
I far as i know you compile with php5-pdo-sqlite, but this was only tested
on debian. Last time i looked this supports sqlite 3.2.8 and you have to use
php's pdo functions and not the sqlite functions which only work with v2.
- Original Message -
From: "Michael Young" <[EMAIL PROTECTED
I am still having some problems compiling my code. I suspect it maybe
something to do with my app not linking (ld) with sqlite libraries, but I do
not know how to do this or it could be something else.
Can you advise?
-
/usr/src/logger-1.2-beta3/src/lo
Nearly there just a couple of outstanding issues any help apreciated
Error:--
make: Warning: File `logger.cpp' has modification time 45 s in the future
g++ -c -Wall -O -g logger.cpp -o logger.o
logger.cpp: In function `void* start_one_channel(void*)':
ntf(stderr, "SQL error: %s\n", zErrMsg);
sqlite3_free(zErrMsg);
}
sqlite3_close(db);
-------
Lloydie T
- Original Message -
From: "Teg" <[EMAIL PROTECTED]>
To: "Lloyd Thomas"
Sent: Sunday, September 10, 2006 12:47 AM
Subject: Re[2]: [sqlite
all_time)values('details.inout','details.statime)"
Do you have any ideas?
Lloydie T
- Original Message -
From: "Teg" <[EMAIL PROTECTED]>
To: "Lloyd Thomas"
Sent: Sunday, September 10, 2006 12:47 AM
Subject: Re[2]: [sqlite] A lillte help addi
(direction, call_time, dest, trunk_no,
file_name)values('"+details.inout+"','"+details.statime+"','"+details.cidn+"'"+details.channel+"','"+details.filename+"')";
- Original Message -
F
I know nothing of C++ and therefore need a lilte help editing a C++ app to
insert some records into a database.
This is where I am so far
#include
sqlite *db;
//insert record into database
db=sqlite_open("/var/tmp/logger/database/logger.db",
AIL PROTECTED]>
To:
Sent: Saturday, March 25, 2006 5:39 PM
Subject: Re: [sqlite] Wierd between results
"Lloyd Thomas" <[EMAIL PROTECTED]> wrote:
if use
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10;
I get 0 results
You DID specify a table in your act
Go back to my original problem if I change 'between 6 and 10' to 'between 6
and 9', I get the expected results.
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 9;
232
Am I finding a bug or is my syntax incorrect?
- Original Message -
From: &q
If i do
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 10 and 6;
I get 633 results.
Is that normal?
- Original Message -
From: "Lloyd Thomas" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 25, 2006 3:48 PM
Subject: [sqlite] Wierd between results
I am not su
I am not sure if I am being crazy, but I seem to be getting a wierd result
when using 'BETWEEN'.
if use
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10;
I get 0 results
but if I do
SELECT count(call_id) as num_rows WHERE ring_time = 7;
I get 39 results
SELECT count(call_id) a
sqlite3 is available in 5.1 using the pdo extensions.
have a look at www.php.net/pdo
I had the same problem with an app I wrote in delphi to insert records and
used php front end to select records
Lloyd
- Original Message -
From: "jack wu" <[EMAIL PROTECTED]>
To:
Sent: Monday, Febru
As you can tell I am no sql guru. Is there anyway I could do the following
without 'group by'.
query:
SELECT C.call_id, C.extn_no, C.dest, U.group_name
FROM call_data AS C, grp_user AS G, user_grp AS U
LEFT JOIN user_grp ON G.group_id = U.group_id
LEFT JOIN grp_user ON C.extn_no = G.extn_no
WHER
f list)
"Lloyd Thomas" <[EMAIL PROTECTED]> wrote:
Thanks Kimball
Your right about having a little experience. I am
just running into error after error installing apps, but I'm learnoing
slowly. Anyway, I was trying to install the sqlite support for another
ap
ject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)
Lloyd Thomas wrote:
There does not seem to be a library file in /usr/lib/ called
libsqlite3.so.0. would that be the problem. Please bear with me I am a
linux
newbie.
Hello Lloyd,
my reply may be a bit too detailed, but I
ect: Re: [sqlite] Building sqlite 3.2.8 on redhat 9
Lloyd Thomas wrote:
I have compilted tcl, but had a problem with tk. having compiled sqlite3
I
get a new error trying to run sqlite3 =
'sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot
open
shared object file: No
tcl
install in redhat was problematic.
http://www.activestate.com/Products/ActiveTcl/
--- Lloyd Thomas <[EMAIL PROTECTED]> wrote:
I am having a problem building sqlite on my redhat 9 box. There seems to
be
a problem with TCL. I am no linux guru, so it some one can poinjt me in
the
right dire
I am having a problem building sqlite on my redhat 9 box. There seems to be
a problem with TCL. I am no linux guru, so it some one can poinjt me in the
right direction that would be great.
here is as far as I get
[EMAIL PROTECTED] sqlite-3.2
bject: Re: [sqlite] tricky date time problem
On Wed, 23 Feb 2005 23:12:41 -, Lloyd Thomas
<[EMAIL PROTECTED]> wrote:
Dennis,
Thanks for you help so far. I think it is easier for PHP to
select
the MAX event. The problem I now have is if there is no records for an
hour,
PHP will th
time problem
On Wed, 23 Feb 2005 23:12:41 -, Lloyd Thomas
<[EMAIL PROTECTED]> wrote:
Dennis,
Thanks for you help so far. I think it is easier for PHP to
select
the MAX event. The problem I now have is if there is no records for an
hour,
PHP will through up an error because MAX
Dennis,
Thanks for you help so far. I think it is easier for PHP to select
the MAX event. The problem I now have is if there is no records for an hour,
PHP will through up an error because MAX must have at least one record to
process, even if it is 0.
Thanks again
- Original Message
Dennis,
Revisted your query. I was being a bit lazy. changed 'select minute,
max(events)' to 'select minute, events' and added 'order by minute' to give
me what I needed.
Thanks
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To: "sqlite-users"
Sent: Wednesday, Feb
indicate where I am going wrong.
Lloud
- Original Message -
From: "Jay" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Wednesday, February 23, 2005 5:39 PM
Subject: Re: [sqlite] tricky date time problem
--- Lloyd Thomas <[EMAIL PROTECTE
sults 'i'
as a datatime modifier in the event_data table. Not much luck though.
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 23, 2005 12:26 PM
Subject: Re: [sqlite] tricky date time problem
On Mon, 2005-02-21 at 21
ion <= 1081335540
The result I get is
0|15
I was expecting 60 result rows
any Ideas? Is this a version 3 operator only?
- Original Message -
From: "Lloyd Thomas" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 22, 2005 11:41 PM
Subject: Re: [sqlite] tricky date time pr
Thanks Jay/DRH,
this looks more promising (The "%" operator
gives you remainder after division). Still not sure how I could apply it to
start and end unix times.
The columns I have are :-
hour start = start time of query for event (unix time)
hour end = end time of quer
might try that.
|
---
How would you do that in C?
- Original Message -
From: "Jay" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Tuesday, February 22, 2005 2:00 AM
Subject: Re: [sqlite] tricky da
thanks for your reply. I think writing a new function is beyond me at the
moment as I have no knowledge of C. I have found the problem with my
datetime modifiers.
I am trying various queries but still getting no results.
I think the best way to attack this is using the my minute integer table
-
me between
datetime('2004-04-07 10:00:00','+1 minutes') and datetime ('2004-04-07
10:59:59','+1 minutes');
returns nothing.
Am I using the right datetime modifiers?
- Original Message -
From: "Lloyd Thomas" <[EMAIL PROTECTED]>
To:
I have a query which calculates the number of events during an hour by the
minute. It needs to work out which minute has the most events and the
average events during that hour. So it should return an array of 60 results
for an hour where I can use the MAX() feature in php to find the peak
mi
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 12, 2005 5:21 PM
Subject: Re: [sqlite] add new column to table
Lloyd Thomas wrote:
Thanks Dennis.
As long as I know where I stand. I can probably use PHP or Delphi
to update each row manu
e] add new column to table
Dennis Cote wrote:
Lloyd Thomas wrote:
Thanks. That is going OK but I am having a problem with updating the
new column with the info I need. It seems to update with the same
entry from my users table to all rows.
UPDATE call_data SET caller_name = (SELECT firstname
regarding UPDATES with SUB SELECTS. What is
the URL?
Lloyd
- Original Message -
From: "Bert Verhees" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 11, 2005 7:55 AM
Subject: Re: [sqlite] add new column to table
Op maandag 10 januari 2005 23:56, schreef Lloyd Thomas:
Thank
UPDATES with SUB SELECTS. What is
the URL?Lloyd- Original Message -
From: "Bert Verhees" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 11, 2005 7:55 AM
Subject: Re: [sqlite] add new column to table
Op maandag 10 januari 2005 23:56, schreef Lloyd Thomas:
Thanks. That is g
= (SELECT extn_no FROM call_data));
I have missed something?
- Original Message -
From: "Lloyd Thomas" <[EMAIL PROTECTED]>
To:
Sent: Monday, January 10, 2005 9:08 PM
Subject: Re: [sqlite] add new column to table
Thanks Paul,
I have used that example before
another table.
Lloyd
- Original Message -
From: "Paul Dixon" <[EMAIL PROTECTED]>
To:
Sent: Monday, January 10, 2005 5:50 PM
Subject: Re: [sqlite] add new column to table
Lloyd Thomas wrote:
I wish to create a new column in a table and add data, which is queried
from an
I wish to create a new column in a table and add data, which is queried from
another table.What is the best way?
Lloyd
Hou can try libsql as a component for Delphi (more of a wrapper). I have
used it so far, but only for sqlite2.8.x. I don't have much programming
experience, but to date I have not had any real problems using sqlite as a
database.
Lloyd
- Original Message -
From: "Ahmet Aksoy" <[EMAIL P
Hi, I am having a problem with the following query. It seems to force php to
timeout after 30secs. The query goes through 150K records. Is there anything I
can do to speed it up?
code-
SELECT call_id, C.extn_no AS extn_no, dest, dest_name, call_time, durat
Hi, I am having a problem with the following query. It seems to force php to
timeout after 30secs. The query goes through 150K records. Is there anything I
can do to speed it up?
code-
SELECT call_id, C.extn_no AS extn_no, dest, dest_name, call_time, durat
If I change the call_time to an integer column, storing unix time and make
it hte index, would this help?
- Original Message -
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 16, 2004 11:10 PM
Subject: Re: [sqlite] Speeding up quer
Hi again,
Th
There are no indexes in may tables. Please find the following schemas for my
tables. Would it make more sense to convert my datetime columns to
microtime?. What other recommendations would you make for these tables?
CREATE TABLE users (
user_id INTEGER PRIMARY KEY,
extn_no varchar(16) default N
I am have a problem with a query which may well have over 200,000 records. I
have building a website using PHP and PHP is timing out after 30secs due the
the size of the call_data table (I think). Is there anyway I can improve the
following query so that it is faster. I think I am using sqlite 2
May try something like
WHERE julianday(DBTimeStamp) < julianday('2004/4/4')
but I might be wrong.
Lloyd
- Original Message -
From: "Shawn Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 3:33 PM
Subject: RE: [sqlite] Sort by TIMESTAMP?
> You right, I
Thanks Christian,
Although that makes sense I can find nowhere on the
net which explains how to dump the data within a transaction.
Do you have an example.
Lloyd
- Original Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: "Lloyd thom
Forgive my ignorance, I have yet to use a transaction and therefore can you
give me an example.
Lloyd
- Original Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: "Lloyd thomas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesd
Which is the best way to backup rows which meet a certain date criteria?
ie WHERE data is <= '2003-11-20'.
Would I need to select and save the data to a temporary table and then DUMP the temp
table.
Ok,
I just tried the query using the sqlite command tool 2.8.12 and I
get no results, whereas if I use PHP5 with sqlite 2.8.11 I get the expected
results.
Can some one tell me why this is or what I am doing wrong?
- Original Message -
I have a query which successfully runs on PH
I have a query which successfully runs on PHP5, which I beleive has sqlite 2.8.11
embedded, but run it in sqliteplus (windows GUI using 2.8.12) it does not return any
results. I have check with eZtools the provider of Sqliteplus and they can not find
fault with their program.
Is there any differ
Thanks Ken,
You make it look so simple.
Lloyd
- Original Message -
From: "Williams, Kenneth (Ken) (TLR Corp)" <[EMAIL PROTECTED]>
To: "Lloyd thomas" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, April 12, 2004 3:50 P
x27;1'or G.group_id is null;
- Original Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: "Lloyd thomas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, April 11, 2004 9:3
I have a table with user id's and another with user id's linked to a group.
users table
|user_id| username |
| 1 | Lloyd Thomas|
| 2| John Smith |
Group table
|group id| user_id|
| 1 | 1 |
I am trying to create a query which selects a use
Thanks.
Lloyd
- Original Message -
From: "Kurt Welgehausen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 11, 2004 4:58 PM
Subject: Re: [sqlite] Matching telephone strings
> > ..., but is it correct?
>
> No, very dangerous. You're depending on the values of band
> and
>I think I have sussed it.<
Well not quite!!
If I extend the 'select' parameter to include other columns, there are
instances where the results in those columns may not be related to what is
in the left columns (as I would expect) and if you group the results, you
end up with more than one result(
I think I have sussed it. If you can see something wrong with the follwing
let me know.
code-
SELECT MAX(areacode) AS areacode FROM stdcodes WHERE '0018764582' LIKE
areacode || '%';
---
> Thanks Kurt,
>
Thanks Kurt,
The GUI I was using to run the query seems to be using
an old version of the SQLite DLL. I haved tried another one and the query
has got me closer to what I want.
The problem I now have is that I am getting too many results.
ie.
SELECT areacode FROM stdcodes WHERE '
I tried the follwing with no results:
select areacode from stdcodes where '01865323260' like areacode || '%'
if I do:
select areacode from stdcodes where '01865' like areacode
that works OK, but that is more or less the same as what I do already.
Am I missing something?
- Original Message
I am using delphi to campare telephone numbers against a table of telephone number
area codes. These arecodes can be upto ten digits, so using a for loop, I am comparing
the the first ten digits of the number. If there are no matches I then will delete one
digit from the right of the telephone n
Please ignore this question. I have already work it out ages ago, but had
forgotten.
- Original Message -
From: "Lloyd thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 03, 2004 12:59 PM
Subject: [sqlite] DATE_SUB
Hi All,
I am stil
Hi All,
I am still not quite getting my head round the time functions. I have a MySQL
query which checks minutes within a period for a match for a match.
Can I achieve the same thing in sqlite?
MySQL code--
SELECT TIME_TO_SEC(duration)as durati
Lloyd
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 29, 2004 12:57 AM
Subject: Re: [sqlite] time calculations
> Lloyd thomas wrote:
> > I have a table that shows a list of connections sho
2')
AND (julianday('2003-12-03 18:42') - julianday(duration)) <=
julianday(call_time)
---
Lloyd
- Original Message -
From: "Lloyd thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Satur
I have a table that shows a list of connections showing the time the
connection was finished and the duration.
I wish to show concurrent connections during a particular minute.
for instance the following would show that there was two connections during
2003-12-04 09:27:00
--
- Original Message -
From: "Lloyd thomas" <[EMAIL PROTECTED]>
To: "Kurt Welgehausen" <[EMAIL PROTECTED]>
Sent: Saturday, February 28, 2004 8:34 PM
Subject: Re: [sqlite] time calculations
> Thanks Kurt,
> Nearly there, but not quit
I know there are now some time functions in sqlite, but I did not quite understand the
functions available in it. I apologise for the MySQL references below, but I wish to
achieve the query below with SQLite, assuming some of you are fimiliar with MySQL. Can
you help?
code--
: Re: [sqlite] date/time functions
Lloyd thomas wrote:
> I heard a rumor that there is some dtae/time functions. If so what is implemented?
> I was hoping for YEAR / MONTH functions you get in MySQL.
>
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
--
D. Ric
I heard a rumor that there is some dtae/time functions. If so what is implemented?
I was hoping for YEAR / MONTH functions you get in MySQL.
Lloydie T
73 matches
Mail list logo