thanks for sending tht sample code on how to store and retrieve images into
and from databases
regards
abirami p
- Original Message -
From: "Gerry Snyder" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 11, 2006 7:32 PM
Subject: Re: [sqlite] hi
abiramip wrote:
hi,
how can i im
Hello Dennis, Jay,
Thanks for you suggestions.
The ids are simply returned to the calling
application in a very large array. It's
the API we're writing against; so we can't
deviate from that unfortunately.
Thanks for clarifying the INSERT trigger
behavior.
I'll try your suggestions and see wha
>From http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
Download the source with the .DEF file, then run:
LIB /DEF:sqlite.def
That will make a lib file.
Robert
> -Original Message-
> From: Richard Stern [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 11, 2006 7:19 PM
> To: sqlite-
Hi.
I'm trying to use sqlite with VC++ 2005, I downloaded the
sqlitedll-3_3_7.zip but it seems I need a .lib file as well.
Does anyone know where I can get one?
After reading some messages here, I tried building the source as a .dll
project but all I got was the .dll it didn't make a .lib
I'm s
On Mon, 11 Sep 2006, Dennis Cote wrote:
Not as shown, but you could build the insert statement as a string in
python and then pass that to the execute method. Assuming row is your
string of values:
sql = "insert into component(vote_id, cat, pos, pw) values (" + row + ")"
self.cur.execute(sql)
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
Rich Shepard wrote:
If I have a string variable with 31 fields (integer, text, text, and 28
floats), and the values are separated by commas (and quotes for the
text),
can I insert them into the appropriate table with a single statement such
as this from a python/pysqlite method I'm writing:
Kervin L. Pierre wrote:
I'd appreciate any help or
pointers optimizing the SQL in the main
loop.
for( 'large number' ){
// query1
"SELECT id FROM table
WHERE attr1 = 'a', attr2 = 'b', ..."
if( 'query1 returns no rows' ){
if( 'create flag is on' ){
// query2
[forgot to reply to the list]
-- Forwarded message --
From: Nuno Lucas <[EMAIL PROTECTED]>
Date: Sep 11, 2006 9:07 PM
Subject: Re: Re: [sqlite] met "ARM7TDMI raised an exception,data
abort" when executing sqlite3Parser() in ARM environment
To: [EMAIL PROTECTED]
On 9/11/06, [EMAI
On 9/11/06, Kervin L. Pierre <[EMAIL PROTECTED]> wrote:
Basically, for every iteration we check
that an id exists ( ie. 'query1' ), if
it does we use it. But if the id does
not exist we insert a row ( ie. 'query2'
), then get the 'last_insert_rowid'
(ie. 'query3' ) and use that.
SQL works bes
If I have a string variable with 31 fields (integer, text, text, and 28
floats), and the values are separated by commas (and quotes for the text),
can I insert them into the appropriate table with a single statement such
as this from a python/pysqlite method I'm writing:
self.cur.execute("inser
Good afternoon to all!
Please some one can tell me how to optimize SQLite for an inverted index of
about 100.000.000.000 of rows or please how can I do that with B-Trees or
ISAM. Please help me if you can.. Thanks...
I am doing an GNU search project for my University.
Hello,
I working on a function in our open-source
Outlook plugin [ http://openconnector.org ]
and I've run into some speed issues.
We've been avoiding optimizing for speed
till later but this function is currently
operating at 3 orders of magnitude worse
than acceptible and is slowing down
testin
I'm using CodeWarrior for compiling.
In setting-->Debugger-->OPT tag, I have selected the least optimization(best
debug), and I select optimize for time instead of for space.
I have not found anywhere to thoroughly turn off the opt in CodeWarrior. Did I
make some stupid mistake?
---
I don't think NULL callback and error pointer will be the reason. Because I've
seen this kind of usage in the list for several times.
Anyway, I'll try later and report the result to the list.
If it is a misaligned-pointer problem, what can I do?
I don't make any change to the sqlite source cod
Sarah uttered:
plus, I'm using sqlite-source-3_3_5.
I also find a wired phenomenon:
When I trace into sqlite3Parser(pEngine, TK_SEMI, pParse->sLastToken,
pParse);
the next executed statement pointed by debugger does not match with the
real one, It seems there are one or two lines space. Th
abiramip wrote:
hi,
how can i import gif or jpg files into SQLite database and how can i export the
same image to the local system?
thanks in advance...
Hello,
Frequently it is better to store just the file names in the database and
keep large files separate, so you should consider that,
On 9/11/06, Sarah <[EMAIL PROTECTED]> wrote:
During the execution of a test program in an embedded environment,
after it goes into sqlite3_exec()-->sqlite3_prepare()-->sqlite3RunParser(&sParse,
zSql, &zErrMsg),
the debugger pops "the ARM7TDMI raised an exception,data abort" when the
following s
plus, I'm using sqlite-source-3_3_5.
I also find a wired phenomenon:
When I trace into sqlite3Parser(pEngine, TK_SEMI, pParse->sLastToken, pParse);
the next executed statement pointed by debugger does not match with the real
one, It seems there are one or two lines space. That is to say, the de
Hi,all
During the execution of a test program in an embedded environment,
after it goes into
sqlite3_exec()-->sqlite3_prepare()-->sqlite3RunParser(&sParse, zSql, &zErrMsg),
the debugger pops "the ARM7TDMI raised an exception,data abort" when the
following sentence is executed(bold and underline
hi,
Is it possible to add some informations about locking
mechanism in the wiki page VirtualTables?
I'm facing concurrency problem in developing a cluster
Sqlite database. One table per database. Multiple databases
indexed like x.db, x.db-001, x.db-002, x.db-003, ... each
containing a choosen num
hi,
how can i import gif or jpg files into SQLite database and how can i export the
same image to the local system?
thanks in advance...
22 matches
Mail list logo