On 10/19/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
I agree that it would probably be worth adding a simply note to the
documentation for each API function which states the first version of
sqlite that made the function available.
Can the web pages be set so specific individuals can wiki them?
On 10/16/06, Dave Dyer <[EMAIL PROTECTED]> wrote:
I can't find an example, but it seems like there ought to be
syntax to use bind to inline selection variables, instead of
having to have a callback function.
Something like:
char *forval,*barval;
sqlite_prepare(db,"select ?foo,?bar from table
Java port of the sqlite3 shell courtesy of the brilliant NestedVM UNIX/MIPS
emulation environment:
http://www.sqlite.org/contrib?orderby=date
java -jar sqlite3sh.jar
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> create table abc(a, b, c);
sqlite> insert into abc values (4, 5, 'f
I'll try that next time. This time i found a cheat way around the problem. I
used the sqlite
command line program, which had no problems opening the database, and did a
dump of the db. I then
used the command line program to create a new db, and read in the dump file.
Then i just swaped the
prob
It's possible that the end-of-line characters were converted when you
transferred the DB file from Windows to Linux. This corrupts the binary
format and can happen when you transfer a file over FTP in text mode.
It's worth a shot to first run the DB file through the dos2unix command
then try open
>Either there is a bug in your operating system (you didn't tell
>us what operating system you are using, by the way) or else there
>is still a process holding a transaction open that you are unaware
>of.
It turns out to be the latter.
It would be useful in such circumstances to identify the
pr
hi all,
I'm trying to read a sqlite database that was created as part of a trac
installation. I'm running
ubuntu, python 2.3.4 and pysqlite2
I can read the db fine on a window server.
When i copy the db over to our linux box though, i'm having some problems.
I've written a very simple test scr
Lloyd <[EMAIL PROTECTED]> wrote:
Hi List,
In SQLite, to see the table structure which command can I use?
(as in Oracle's desc )
You can use "select * from sqlite_master;" and there is specific
information available by the pragma command:
http://sqlite.org/pragma.html
d
-
Adriano Ferreira <[EMAIL PROTECTED]> wrote:
Does anyone know where I can get binary files for the Christian
Werner's Java wrapper (sqlite.jar and sqlite_jni.dll) which allows for
a large number of placeholders (something like 256 or so)?
If you are just after a JDBC driver with no arbitrary lim
Only to make things explicit, I believe the failure to get useful
Windows binaries according to the instructions is all mine - some
unfortunate combination of the environment I am using and my lack of
skills.
On 10/20/06, Adriano Ferreira <[EMAIL PROTECTED]> wrote:
Does anyone know where I can g
Does anyone know where I can get binary files for the Christian
Werner's Java wrapper (sqlite.jar and sqlite_jni.dll) which allows for
a large number of placeholders (something like 256 or so)? This is
currently configured by a #define at the file sqlite_jni.c and
defaults to 32. I followed the in
P Kishor schrieb:
On 10/20/06, Paul M <[EMAIL PROTECTED]> wrote:
On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> a new version is available (0.5.1.9) on
> "http://greschenz.dyndns.org/gas.html";.
> this version uses threads for sending files now ! the reply time is
much
hi,
yes, multipart form uploads are possible, and yes, it was a pain :-) but
i developed some http-servers before so i know what to do...
at the moment, i'm still using (heavy transformed) external http-code
(from www.hughes.com.au/products/libhttpd/) which was not able to do
this...
well, be
On 10/20/06, Paul M <[EMAIL PROTECTED]> wrote:
On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> a new version is available (0.5.1.9) on
> "http://greschenz.dyndns.org/gas.html";.
> this version uses threads for sending files now ! the reply time is much
> better now...
Very
On 10/20/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote:
You didn't use the CGI module, did you?
If you must know it was POE based and no I did not use the CGI module. I
have implemented later versions that where capable of using database
servers. SQLite amoung them of course as well as MySQL and
Hi Rohit.
I sent the source code to DRH with the extra functions. I don't myself have
the time now to incorporate the extra functions into SQLite.
I don't know if DRH plans to add the extra functions. If he does not and he
doesn't mind, I am happy to send the source code to anyone that is
inte
* Paul M <[EMAIL PROTECTED]> [2006-10-20 17:35]:
> Can this server handle multipart form uploads(multiple files
> from one form)? I remeber in perl I had to implement the
> support for that and regular form submissions manually. I tell
> you that was a pain.
You didn’t use the CGI module, did you?
On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote:
Hi,
a new version is available (0.5.1.9) on
"http://greschenz.dyndns.org/gas.html";.
this version uses threads for sending files now ! the reply time is much
better now...
Very cool program. I once wrote something like this in perl, bu
On 20/ott/06, at 17:06, Lloyd wrote:
Hi List,
Is there is any easy way to insert a value to a table, if and
only if
it is not existing ?
For example.
If I have these values 1,2,3,4,1,2,3,4
when I insert these to a table
it must be
1
2
3
4
[By using primary key or unique constraint, it
Lloyd wrote:
Hi List,
Is there is any easy way to insert a value to a table, if and only if
it is not existing ?
http://sqlite.org/lang_conflict.html
ON CONFLICT clause
conflict-clause ::= ON CONFLICT conflict-algorithm
conflict-algorithm ::= ROLLBACK | ABORT | FAIL | IGNORE | REPLACE
Hi List,
Is there is any easy way to insert a value to a table, if and only if
it is not existing ?
For example.
If I have these values 1,2,3,4,1,2,3,4
when I insert these to a table
it must be
1
2
3
4
[By using primary key or unique constraint, it will work. But I dont
want sqlite to throw
I suspect a little vs. big endian problem.
chetana bhargav wrote:
Hi,
I saw a strnage problem using unsigned shorts, not sure if any one saw that, I
was using an unsigned short for binding it to integer, the lint wasn't
complaining and everything seem to go ahead fine, when I tested that on
other mail wrote:
is it safe to assume negligable timing differences between using the sql
USING clause vs the sql ON clause in a join?
Devorah,
I would not expect there to be any significant difference.
It should be easy enough to try it both ways and measure the difference.
Then you woul
from the command line in sqlite3:
.schema
Lloyd wrote:
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
---
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, send e
"Kalle Klovn" <[EMAIL PROTECTED]> wrote:
> Yesterday I received the
> SQLITE_CORRUPT error message. This happened on a test system so it is not
> that bad, but I am now very nervous about this happening in my production
> system. Is this a common problem with sqlite?
I get very few reports of dat
Hi,
I saw a strnage problem using unsigned shorts, not sure if any one saw that, I
was using an unsigned short for binding it to integer, the lint wasn't
complaining and everything seem to go ahead fine, when I tested that on
windows, all my querys were returning as expected. But when I moved m
Günter Greschenz wrote:
Hi,
a new version is available (0.5.1.9) on
"http://greschenz.dyndns.org/gas.html";.
I'd just like to confirm that I can still see your site from the UK. ;)
Martin
-
To unsubscribe, send emai
Hi,
a new version is available (0.5.1.9) on
"http://greschenz.dyndns.org/gas.html";.
this version uses threads for sending files now ! the reply time is much
better now...
btw: some time ago someone searched a possibility to expose a sqlite
database over http: have a look at the sqlitebrowse
29 matches
Mail list logo