short as an array of bits
Thanks,
Lloyd
Sorry for asking irrelevant question to this list.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks Igor. This is what I wanted.
On Thu, 2007-03-01 at 07:46 -0500, Igor Tandetnik wrote:
> Lloyd wrote:
> > How can I make an array of bit fields? something like, using the 16
> > bits
> > of a short as an array of bits
>
> You can't. But, if you can us
Thanks John. yes, I am familiar with this way, I just wanted to know
whether there is a way to make bit field array. From Igor's reply I
understood that it is not possible in C.
Thanks,
Lloyd
On Thu, 2007-03-01 at 09:48 -0600, John Stanton wrote:
> Use a mask to load from and store to
, I will have millions of integers to store and retrieve)
What the real data is a network packet dump file. I want to store and
retrieve the location of each packet, in order to make packet reading a
faster way from a very large dump file (in terms of GBs)
Thanks,
Lloyd
des in the data structure and it
will be searched millions of times. The data is not in any ordered form.
Thanks for your information,
Lloyd
__
Scanned and protected by Email scanner
--
(A
structure sizing 70 bytes and the key field would be of size maximum of
20 bytes). (I will see, what is memory based hash)
Thanks and Regards,
Lloyd
__
Scanned and protected by Email scanner
-
y experts ;) (like bloom filter)
Thanks,
Lloyd
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Wed, 2007-04-11 at 10:00 -0500, P Kishor wrote:
> I think, looking from Lloyd's email address, (s)he might be limited to
> what CDAC, Trivandrum might be providing its users.
>
> Lloyd, you already know what size your data sets are. Esp. if it
> doesn't change, putt
Thank you all. I got so many new ideas from your replies. Now I just
have to derive the best solution for me, thanks :)
Lloyd
On Wed, 2007-04-11 at 10:35 -0500, John Stanton wrote:
> You might discover that you can craft a very effective memory
> resident
> storage system using a co
Would anybody suggest a good tool for performance measurement (on
Linux) ?
On Wed, 2007-04-11 at 10:35 -0500, John Stanton wrote:
> You might discover that you can craft a very effective memory
> resident
> storage system using a compression system like Huffman Encoding and
> an
> index method a
Thank you John Stanton. This has opened new doors for me, and think it
would be helpful for others in the list too..
Thanks and Regards
Lloyd
On Thu, 2007-04-12 at 12:34 -0500, John Stanton wrote:
> We use a very simple data retrieval method for smallish datasets. The
> data is just sto
short period of time (10 mins -small input) am not getting
any error. But when it runs for around 1 hour (large input) I am getting
an error called
sqlite 14, cant open database !
What could be the reason for this particular error?
Thanks and regards,
Lloyd
system on my Linux)
Thanks and Regards,
Lloyd
On Wed, 2007-04-25 at 10:13 +0530, Lloyd wrote:
> Hi,
> I am working on Redhat EL4, with sqlite3. In my application (written in
> C++ and wxWidgets, and I use wxSqlite3 wrapper) there a module which
> will be called repeatedly which in tu
Thank you Arjen. I would consider your alternative or I will go for some
other file system. (Because I would have to handle files larger than
2GB)
Thanks and Regards,
Lloyd
On Thu, 2007-05-03 at 13:52 +0200, Arjen Markus wrote:
> Lloyd wrote:
>
> >This error occurs only on FAT 32
In old versions it work... But in new versions (3.* I think) its not
working!
On Wed, 2007-05-09 at 12:11 +0200, Peter van Dijk wrote:
> On 9-mei-2007, at 11:06, A.J.Millan wrote:
>
> > As a suggestion, and even in the risk to abuse of Mr Hipp's
> > patience. Would
> > it be possible to include
y linked, just replace libsqlite3.so with your own.
How should be my own libsqlite3.so looking like. Can you explain the way
I should make the library? I would like to learn this technique :)
> If it is statically linked and has -g symbols, use gdb.
> If it's stripped,
On Wed, 2007-05-23 at 09:09 -0700, Joe Wilson wrote:
> --- Lloyd <[EMAIL PROTECTED]> wrote:
> > On Wed, 2007-05-23 at 07:21 -0700, Joe Wilson wrote:
> > > > I've a "black-box" (Linux) program - so no source available - using
> > > a
> > &g
doesn't seem to work for me
alter table x add (v3 number,v4 number);
Regards,
Lloyd
On Tue, 2007-06-05 at 11:25 +0530, Kirrthana M wrote:
> Hi all,
> I have created a table with two columns c1 and c2 and inserted some
> values into,in future i may include some additional
Hi,
I would like to know the reserved characters which cannot be used in
inserting a string.. (like ",',...).
Thanks in advance,
Lloyd
__
Scanned and protected by Ema
Hi,
Can I know how SQLite performs 64bit operations (addition,
multiplication, division) on 32bit machine?
Thank you very much,
Lloyd
__
Scanned and protected by Email scanner
Thanks Andy.
So, SQLite doesn't have its own features to manage this? So I must be
able to perform 64bit operations on a 32bit machine using C. How can I
do that? or how to declare a 64bit integer on a 32bit machine?
Thanks,
Lloyd
On Thu, 2007-07-12 at 15:06 -0500, Andrew Finkenstadt
Thanks Igor :)
Regards,
Lloyd
On Fri, 2007-07-13 at 00:18 -0400, Igor Tandetnik wrote:
> Lloyd wrote:
> > So, SQLite doesn't have its own features to manage this? So I must be
> > able to perform 64bit operations on a 32bit machine using C. How can I
> > do that?
Thank you very much Andrew.
Regards,
Lloyd
On Thu, 2007-07-12 at 23:37 -0500, Andrew Finkenstadt wrote:
> Use sqlite_int64 as your type. That typedef supports 'long long' or 'signed
> __int64' or whatever the compiler environment needs.
>
> --a
>
> On 7/
Hi Punkish,
I think after installing the library, and making the path entry in
the /etc/ld.so.conf (If it is not there), simply running the "ldconfig"
command will serve your need.
Regards,
Lloyd
On Thu, 2008-03-13 at 12:09 -0500, P Kishor wrote:
> I am not at all conversant
Hi,
In the test folder of sqlite3 source distribution I saw so many test
scripts. How can I run these tests? I am curious to know the various
testing methods used in sqlite.
Thanks,
Lloyd
__
Scanned and protected by Email scanner
e sqlite library and how
to install it in my machine. Awaiting for your kind reply.
Thanks and regards,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
r/lib/sqlite-3.3.7
How can I solve this? From where do I can get an installable copy if the
SQLite library for linux?
Thanks,
Lloyd.
On Tue, 2006-09-26 at 13:17 +0100, Lloyd Thomas wrote:
> Hi Lloyd,
> I had exactly the same problem being new to C++. These are the
> steps I took
ferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
and the error continues
How can I resole this. Please help me...
Can I use the library alone with
system.
Please help me.. If I am dealing with the wrong file, please let me know
from where I can get the needed installable library.
Thanks for your clear and patient reply.
Thanks,
Lloyd.
__
Scanned and
Thanks everybody, I have downloaded the library RPM from
http://rpm.pbone.net/
and the library name is
libsqlite-3.2.1-1.i386.rpm
It may be useful for newbie like me...
and did as what you said. And works fine...
Thanks,
Lloyd.
On Wed, 2006-09-27 at 10:08 +0200, Markus Hoenicka wrote
Hi All,
I have downloaded the SQLite library (sqlite-3.3.7.so.gz) from the
homepage. But I don't know how to install it. Please help me. My Redhat
Enterprise Linux machine runs on i386 architecture.
Thanks and Regards,
Lloyd.
__
Scanned and protect
I think you are asking for this... This is the case when we use
wxSQLite3.
wxSQLite3ResultSet result = samp.ExecuteQuery(wxT("select name,age from
test"));
while (result.NextRow())
{
cout << (const char*)(result.GetString(0).mb_str()) << result.GetInt
(1)<< endl;
}
On Fri, 2006-10-06 a
,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
> Are these inserts in 1 transaction or 1000?
Yes it is in 1000 transactions.
For me consistancy, atomicity...(ACID) are not a problem. But the speed
of operation is major constraint. How can I achieve speed in insertion
cases like this?
Thanks for your informative reply.
Lloyd.
On
Hi List,
In SQLite, to see the table structure which command can I use?
(as in Oracle's desc )
Thanks,
Lloyd
__
Scanned and protected by Email scanner
-
To unsubscribe,
throw error]
How can I get this done?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
a combined primary key of text and integer.
Is this the expected performance? Can I improve it anyway? (I am using
the wxSQLite wrapper class)
Thanks,
Lloyd.
__
Scanned and protected by Ema
Hi,
When this 3M inserts are performed, it takes 130 more seconds compared
to the actual application running time. The actual application run time
is 20 seconds but when this 3M inserts are performed it takes 150
seconds.
Is there any way to reduce the time ?
Thnaks,
Lloyd.
On Mon, 2006
use the interface provided by the
sqlite. How can I open the database in SQLite ?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL
;: file is encrypted or is not a
database .
How can I open the database using sqlite command line? ]
Thank you very much.
Lloyd.
On Tue, 2006-10-24 at 11:02 +, [EMAIL PROTECTED] wrote:
> Lloyd <[EMAIL PROTECTED]> wrote:
> > Hi List,
> > Whether the data base which we create
Sorry for my mistake.
I was creating database using sqlite3 API and trying to open it with
sqlite command line client version 2.7
Thanks a lot.
Lloyd.
On Wed, 2006-10-25 at 11:51 +0530, Lloyd wrote:
> Thanks for your informative reply.
>
> I would like to know, whether I can open a
Hi list,
can I insert a hexadecimal value to an integer field? if yes How can
do that?
Thanks,
Lloyd
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to
the full path of
the file. It will work fine.
Thanks,
Lloyd.
On Fri, 2006-10-27 at 12:17 +0530, sandhya wrote:
> Hi,
>Is it possible to refer db file from other than the Current project
> location.If Yes,How can we refer(tell) the location of the DB file to the
> project.Pl
Most probably it will be a memory leak in your program. We must release
the dynamically allocated memory ourselves. So check whether you are
forgetting to do that. Most probably that leak will be happening inside
some loops or repeatedly calling functions.
On Fri, 2006-10-27 at 17:00 +0100, Ben C
Which platform are you using? Do you (application) have enough
permission to create files in the specified location ?
On Sat, 2006-10-28 at 16:19 +0530, [EMAIL PROTECTED] wrote:
> Hi All,
>
> I am using sqlite3_open() in my program. It is returning
> error code 14(file not found) ever
I don't know whether I am right in this perspective. Just to know
whether sqlite is causing the high memory usage, comment the commands
(statements) related to sqlite and check the memory status.
Thanks,
Lloyd.
On Mon, 2006-10-30 at 12:45 +, Nuno Lucas wrote:
> On 10/30/06, Ben
Hi,
How can I manage date and time using sqlite? [Do I have to do it
outside sqlite?]
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to
Thanks gg and Craig Morrison for your informative reply.
I would like to know one more thing, can I use these date and time
functions with comparison operators? Will they return the correct result
or as per the string comparison rules?
Thanks again,
Lloyd.
On Tue, 2006-11-07 at 04:25 -0500
I retrieve the accurately converted date and time ?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
packets, And
I want to display it accurately. (as in the localtime).
Which way can I prefer ?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks Craig Morrison. Now I got the idea clearly.
On Wed, 2006-11-08 at 00:55 -0500, Craig Morrison wrote:
> Lloyd wrote:
> > select datetime(1162961284,'unixepoch','localtime');
> >
> > 2006-11-08 10:18:04
> >
> > The result is
wrapper class. All these are performed from a single program.
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks Clay Dowling,
Yes there is a function for fanalize function. Now the problem is
solved.
On Tue, 2006-11-14 at 08:02 -0500, Clay Dowling wrote:
> Lloyd,
>
> You need at some point to call the sqlite3_finalize function. I don't use
> wxSqlite, but if it's not handle
,
Lloyd.
On Wed, 2006-11-15 at 14:46 +0530, Lloyd wrote:
> Hi,
> I have opened a database, created tables and inserted data to it in a
> single transaction. Then I have closed the data base. Then I reopened
> the database and tried to update the table entries. But it throws an
Are you forgetting to close the database?
On Fri, 2006-11-24 at 02:03 -0800, mithin wrote:
> Hi,
>
> In my application I am using SQLite 3 c++ API. Everything works fine till my
> application is open. While doing any transaction a journal file is created.
> Once I close the app, the journal file
I think, Through the command line mode it is impossible.
For this you have to write a program which open and reads the (binary)
data in file and inserts it to the sqlite database.
Thanks,
Lloyd
On Tue, 2006-11-28 at 13:36 +0800, LuYanJun wrote:
> Can anybody give a simple example
Hi,
How much time can it take to perform 2000 selection queries on the
same database ? Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?
Thanks,
Lloyd
__
Scanned and protected by Email scanner
The way I am dealing with this is...
First convert the IP to a 32bit integer. (In the system it will
represented as a 32bit integer)
Store it in the database.
Perform the comparison operations on this stored data.
Thanks,
Lloyd
On Mon, 2006-12-04 at 22:07 -0500, Igor Tandetnik wrote:
> Ke
I feel little difficulty in understanding what you actually want (I
thing the same is for all...). So could make it more clear? so that your
problem can be solved fast!
Thanks,
Lloyd.
Yes, they are stored as INTEGER. and the conversion outside sqlite
> is simple. However, I still need
where clause to add, so my final query
become
select a from mytable where (b=0) and
and this is a syntax error.
Is there any option to add a null clause after the 'and' ?
Thanks,
Lloyd
__
Scanned and protected by Ema
Thanks, 0=0 works well enough for me. (This hint is what I wanted)
Thanks again,
Lloyd
On Wed, 2006-12-06 at 10:00 +0100, Mario Frasca wrote:
> Lloyd wrote:
>
> >select a from mytable where (b=0) and
> >
> >and this is a syntax error.
> >
> >
> you
ected. (no result is shown)
what could be the reason? Is there any better way for me to achieve the
same result?
Thanks and Regards,
Lloyd
__
Scanned and protected by Email scanner
-
Thanks Karthick. My code too works fine... (I made a small typo mistake in
query, which executed silently)
But I guess your method is the right one.
Regards,
Lloyd
On Wed, 2006-12-20 at 16:54 +0530, Karthick V - TLS , Chennai wrote:
> Let the time zone given by user
> +0530
>
&g
Ethereal make use of Lemon
On Fri, 2006-12-29 at 11:08 -0400, Cesar Rodas wrote:
> Where can i find a tutorial with examples of how to use LEMON parser...
> because i need to build interpreted language
>
> Thanks to all
__
Scanned and protected by Email scann
addrA
2 B addr
3 C addrC
4 B addr
But the Output we want is
No. NameAddress
1 A addrA
2 B addrB
3 C addrC
4 B addr
If my question is not clear, I am ready
Thank you very much Dan.
On Fri, 2008-10-17 at 14:10 +0700, Dan wrote:
> On Oct 17, 2008, at 1:43 PM, Lloyd wrote:
>
> > Hi,
> >
> > Lets assume a table having following data
> >
> > No. NameAddress
> >
> > 1
To escape "'" use cosecutive "'" , i.e "''"
On Wed, 18 Feb 2009 10:32:28 +0530, J. R. Westmoreland wrote:
> I can't remember how to escape a "'" in a string.
>
> My statement looks something like:
>
> "insert . values ('DAY'S AVE' .);
>
>
> It's been a long day.
>
> Thanks in advance.
>
>
> J.
base would require
more memory.
Thanks,
Lloyd
__
Scanned and protected by Email scanner
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thank you Igor and Dan. Now I am clear about the concept.
On Sat, 28 Feb 2009 20:07:45 +0530, Dan wrote:
>
> On Feb 28, 2009, at 8:44 PM, Lloyd wrote:
>
>>
>> Hi,
>>
>> When we create a view what happens internally in sqlite? Does it
>> select
>> all
Have you created the table? what is the name of your database? If the
database is available in the disk, open it using sqlite shell.
Then execute the query "select * from sqlite_master;"
If your table is present in the database, it will be returned by this query
On Sun, 22 Mar 2009 19:03:2
hreads are obtaining the DB handle at the same time
using sqlite_open - with wrtie permission- is it possible?) I have tried
compiling the application with both -DSQLITE_THREADSAFE=2 and
-DSQLITE_THREADSAFE=1.
Any hint would be very helpful...
Thanks a lot,
Lloyd
__
ed, I am ready to
wait and open it)
You men to handle the BUSY by waiting for some time and trying to execute
sqlite3_step?
Thanks a lot,
Lloyd
__
Scanned and protected by Email scanner
___
sqlite-users mailin
So it means we can have mor than one valid db handle?
Thanks,
Lloyd
- Original Message -
From: "Pavel Ivanov"
To: "General Discussion of SQLite Database"
Sent: Wednesday, July 07, 2010 6:40 PM
Subject: Re: [sqlite] sqlite3_step returns sqlite_busy
>>
Hi,
Which are all the type of SQLite APIs can return SQLITE_BUSY?
sqlite3_open_v2
sqlite3_prepare_v2
sqlite3_step
sqlite3_finalize
sqlite3_bind_blob
sqlite3_column_int
Thanks,
Lloyd
__
Scanned and protected by Email scanner
Hi,
Lets assume that we have a very simple without any indexing or constraints. Now
we have inserted some data to the table. When we do a simple "select" query, is
it guranteed that the rows will be retrieved in the same order as they are
inserted?
Thanks a lo
Thanks Swithun. I dont have any supportive column in table to issue "order
by". Can it be achieved by issuing an "ordr by" query on "row_id" (used by
sqlite internaly)?
Thanks,
Lloyd
> Hello
>
> L> Lets assume that we have a very simple without an
Thanks Jay for your detailed reply.
I would be more happy if the SQLite documentaion include the error codes
each function can return.
Thanks a lot,
Lloyd
- Original Message -
From: "Jay A. Kreibich"
To: "General Discussion of SQLite Database"
Sent: Thursday, J
ot;,&sz,0);
if(sqlite3_deserialize(dbHandle, "main", mem, sz,
sz,SQLITE_DESERIALIZE_READONLY) != SQLITE_OK){//error}
char* Query = "select * from test";
sqlite3_stmt *statement = nullptr;
int res=sqlite3_prepare_v2(dbHandle, Query,
On Fri, Mar 1, 2019 at 4:09 PM Simon Slavin wrote:
> On 1 Mar 2019, at 10:27am, Lloyd wrote:
>
> > I am able to serialize, deserialize and prepare a SQL query against the
> rollback database. When I do the same against the WAL database file, the
> 'prepare'
ed it using
the dumpbin utility. But the dll downloaded from www.sqlite.org exports
symbols.
How can I build the dll correctly?
Thanks,
Lloyd
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/ma
Hi,
I have a "buffer" containing data read from a file-based sqlite database.
Is there any possibility for processing this "buffer" to query the data?
Thanks,
Lloyd
___
sqlite-users mailing list
sqlite-users@mailingl
>
>
> But I imagine you had a more specific question in mind - please ask
> exactly what you would like to know, and make sure to include all the
> details what we need to know to be able to give answers or advice that
> somewhat resemble the truth.
>
> (Is the buffer a queried cursor? a part of th
>
> Only https://www.sqlite.org/draft/c3ref/deserialize.html comes to mind,
> and that's brand new and assumes the buffer comes from the companion
> serialize. Not sure it's release in 3.24 yet. Google finds it in the Draft
> only. --DD
Deserialize cannot solve my problem as it needs a valid db c
>
>
> Do what you want, but remember you can always create a valid database
> connection using sqlite3_open(":memory:", &db) and then do the
> sqlite3_deserialize().
>
>
Thank you Richard, I didn't know that it can be done this way.
___
sqlite-users maili
>
> I see Richard already pointed out that you can create a connection to a
> strictly in-memory DB which doesn't touch a file, and then Deserialize to
> it. Just to emphasize, if you can make that work, it is definitely worth
> it. From my experience, making the VFS will easily sink around 30 hou
rSize, BufferSize, SQLITE_DESERIALIZE_READONLY);
if (RetSqlite != SQLITE_OK)
throw std::exception("sqlite3 db open fialed");
sqlite3_stmt *statement = nullptr;
string Query = "select content,dateAdded,lastModified FROM moz_annos";
if (sqlite3_prepare_v2(dbHand
s for 32-bit Windows (.NET Framework 4.6)".
sqlite-netFx46-setup-bundle-x86-2015-1.0.102.0.exe. But it doesn't seem to
support EF.
Thanks a lot,
Lloyd
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlit
e based on my entity classes?
I couldn't find any tutorial on using System.Data.SQLite with Entity
Framework.
Any hint/help/a link to tutorial is greatly appreciated
Thanks,
Lloyd
___
sqlite-users mailing list
sqlite-users@mai
19, 2016 at 6:02 PM, Lloyd wrote:
> Hi,
>
> I am trying to use SQLite with EntityFramework6 on a .Net application.
>
> I have referred the documentation, created the app.config file as
> specified in the documentation. When I created a sample C# file as in the
> documentation,
DB first worked for me. But I didn't find it documented that code first
wont work.
On Tue, Aug 30, 2016 at 7:06 PM, grégoire saint-ellier <
greg.stell...@gmail.com> wrote:
> Thank you for your answer. So wich approach should I use ? DB first? Code
> First ?
>
> Regards
>
> 2016-08-30 14:08 GMT+02
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",
(direction, call_time, dest, trunk_no,
file_name)values('"+details.inout+"','"+details.statime+"','"+details.cidn+"'"+details.channel+"','"+details.filename+"')";
- Original Message -
F
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
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
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*)':
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
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
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
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
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
1 - 100 of 187 matches
Mail list logo