This was posted previously, but in case you missed the subject line,
here is a restatement.
Google and O'Reilly honored five open source people whose
contributions over the past year have been exceptional in five
categories: Communicator, Evangelist, Diplomat, Integrator, and
Hacker. Richard was
Very cool! Congrats!
On 8/4/05, Mike Owens [EMAIL PROTECTED] wrote:
This was posted previously, but in case you missed the subject line,
here is a restatement.
Google and O'Reilly honored five open source people whose
contributions over the past year have been exceptional in five
[05-08-2005 7:08, Mike Owens escreveu]
This was posted previously, but in case you missed the subject line,
here is a restatement.
Google and O'Reilly honored five open source people whose
contributions over the past year have been exceptional in five
categories: Communicator, Evangelist,
[04-08-2005 21:31, Dan Wellisch escreveu]
We just put a SQLlite application in production. It handles the display
of ISO 8859-1characters just fine if they appear in the search
results.
Please bear in mind that sqlite3 expects UTF-8 input, not ISO8859-1, so
you need to make sure you convert
Hi,
I am using PRAGMA table_info(table-name); to the the schema info of a
table, but I could not customize the returned field name, such as:
I wish cid to be ColumnID.
normally we do by this:
SELECT cid AS ColumnID FROM (table-name);
but now I could not. is there anyway work out?
Congratulations! I have to agree with Google and
O'Reilly on this. No small feat indeed!
Sid
--- Mike Owens [EMAIL PROTECTED] wrote:
This was posted previously, but in case you missed
the subject line,
here is a restatement.
Google and O'Reilly honored five open source people
whose
On Aug 5, 2005, at 6:51 AM, scunacc wrote:
I'm probably doing all sorts of things wrong here, but this seemed
enough (by empirical messing around :-) to get the answers I was
interested in, which was whether the SQL would parse or not for a
given
statement.
It might be nice if there were
Id like to import a csv, comma delimited file, into a table (sqlite3
db) in my Ruby application. I can do it either of three ways:
1.) With a SQL statement like the COPY command. Ive read this was
taken out, but then found a place that said it has been reimplemented?
Ive had no luck with
SQLite is a very great engine.
Thanks for the good work, well earned this award, congratulations.
Good luck
--
Met vriendelijke groet
Bert Verhees
ROSA Software
Without SQLite I couldn't have done some of my projects. It's amazing
at what it does.
Thanks a lot and congratulations!
-- Tito
---
Tito Ciuro
Webbo, L.L.C.
http://www.webbo.com
Can you write C?
Steal the code from the sqlite command line tool source. :)
On 8/5/05, Joe Noon [EMAIL PROTECTED] wrote:
Id like to import a csv, comma delimited file, into a table (sqlite3
db) in my Ruby application. I can do it either of three ways:
Ditto, I can't imagine how the industry as a whole has done without something
like Sqlite for so
long. I plan to use Sqlite in almost everything I build going forward--it's so
much better than
XML files or plan text.
Congratulations! and Thanks for sharing such a powerful and useful
Joe Noon wrote:
Id like to import a csv, comma delimited file, into a table (sqlite3
db) in my Ruby application. I can do it either of three ways:
1.) With a SQL statement like the COPY command. Ive read this was
taken out, but then found a place that said it has been reimplemented?
Ive had
Dear Will,
It might be nice if there were a sqlite3_check_syntax function in the
API. Another possibility that uses a function in the public API is to
call sqlite3_prepare on the statement(s).
Perhaps, but as I was working up to this - dry-running and dbx/gdb'ing
the code I wanted to avoid
Dear all,
You can use a system call to execute a command like the following;
sqlite3 -separator , test.db .import test.csv sometable
I do something very similar to this from a Perl application for speed.
It's about twice as fast as doing this from DBI. (Benchmarked on very
large files).
I
You can use a system call to execute a command like the following;
sqlite3 -separator , test.db .import test.csv sometable
That is exactly what I needed! Thanks a ton.
Joe Noon
Hello Cory
I got the .lib file. Thank you for your help. I really appreciate it.
One more question, I found that two external variables sqlite3_version and
sqlite3_temp_directory do not work in Windows version. Do you know how to
fix this problem?
Bo Chen
you can build a .lib from the .def
Allow me to show my ignorance here, but I use the tcl bindings to SQLite AND
I am SQL-naive.
All my stuff (so far) have been done with
sqlite db mydb-name
...
db eval insert|update|delete ...
...
How does one get the return code to determine that the DB is locked? Would
I change my call to
My congatulations! It's really magnificant :)
On Aug 5, 2005, at 9:15 AM, scunacc wrote:
Perhaps, but as I was working up to this - dry-running and dbx/gdb'ing
the code I wanted to avoid actually verifying the SQL against extant
database tables (and running any kind of caching preparation), so I
was approaching it from a ground up
You can use: catch {db eval your sql here} catchErr
Catch will return 0 (zero) for success, non-zero for failure.
So, you can use something like this:
if { ! [catch {set selectResult [eval db select x from y where z =
'blah']} catchErr] } {
puts Failed - the error is $catchErr
} else {
So, you can use something like this:
if { ! [catch {set selectResult [eval db select x from y where z =
'blah']} catchErr] } {
puts Failed - the error is $catchErr
} else {
puts selectResult= $selectResult
}
Except that you've got the if/else clauses reversed
(or just remove the !)
You are correct Sir! I stand corrected on all counts.
The if/else and eval db is what happens when you just type something
and don't actually run it... Could definitely be confusing to a
beginner.
I'll try to be more diligent in the future.
Thanks,
Jeff.
-Original Message-
From: Kurt
Thanks, everyone! I understodd the pseudo-code, Jeff!
So what I think I'll do is:
set cnt 5
while {{[catch {db eval my-sql-statment} sqlerr}$cnt} {
after2000
incr cnt -1
}
Haven't tried this, either!
On 8/5/05, Dinsmore, Jeff [EMAIL PROTECTED] wrote:
You are correct Sir! I stand
24 matches
Mail list logo