Re: [sqlite] NULL popping up in INSERTed strings

2004-01-05 Thread Darren Duncan
At 9:02 PM -0600 1/5/04, Nate Bargmann wrote: >I'm working with SQLite through a Perl script to store some data files >on CD-ROM into tables. Everything has gone rather well considering I am >learning SQL and SQLite as I go along. The data files are CSV and >appear to be an SQL variant used by a

Re: [sqlite] Sqlite & COM/EXE server

2004-01-05 Thread Lindsay Mathieson
Eugene Lin wrote: Bert, It is a COM-related problem, not a SQLITE problem I can now tell you that it IS a sqlite problem NOT a COM problem. Sqlite is trying to create its temporary database at some location (which I'm not sure where) and it failed. I have found that you can force sqlite t

[sqlite] NULL popping up in INSERTed strings

2004-01-05 Thread Nate Bargmann
Hi All. I'm working with SQLite through a Perl script to store some data files on CD-ROM into tables. Everything has gone rather well considering I am learning SQL and SQLite as I go along. The data files are CSV and appear to be an SQL variant used by a proprietary SQL engine installed by the C

[sqlite] Version 2.8.9

2004-01-05 Thread D. Richard Hipp
Version 2.8.9 of SQLite is now available on the website http://www.sqlite.org/ This version fixes a critical bug. Upgrading is recommended. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EM

Re: [sqlite] Sqlite & COM/EXE server

2004-01-05 Thread Eugene Lin
Bert, >It is a COM-related problem, not a SQLITE problem I can now tell you that it IS a sqlite problem NOT a COM problem. Sqlite is trying to create its temporary database at some location (which I'm not sure where) and it failed. I have found that you can force sqlite to store its temporary d

[sqlite] Critical SQLite bug fixed

2004-01-05 Thread D. Richard Hipp
All versions of SQLite from 2.8.8 and back contain a critical bug that can result in index corruption if you try to insert a large negative number (a number less than -2147483648) into an indexed numeric column. A fix for this specific problem has been checked into CVS. Extensive testing is curre

[sqlite] implement a few sqlite functions...

2004-01-05 Thread Christian Kienle
Hi guys, first thank you a lot for the great SQLite database. I just want to introduce my work: At the moment I write a little cgi library with C++. The following thins work fine: - parse GET/POST (Query String) - (un)set cookies - file functions - string functions - html output optimation -

Re: [sqlite] Question on column headers

2004-01-05 Thread Kurt Welgehausen
>> ... is it proper to allow column names with spaces ... You can do it in SQLite: "my column" or [my column] or 'my column'. The double quotes are allowed by SQL92 as "aids for transitioning from ISO/IEC 9075:1989 to this International Standard", and if I understand correctly, only in weak imple

[sqlite] Date Time, and now without make-up codes

2004-01-05 Thread Bert Verhees
First of all, very good, that de sqlite-list does not accept codes, although it sometimes slips through. Excuse for my previous mail. But now, what I have to say. > > CREATE TABLE Allan (DateTimeField DateTime); > > INSERT INTO Allan (DateTimeField) VALUES ('2004-01-04 12:00:00'); > > SELECT Da

[sqlite] Date Time notation

2004-01-05 Thread [EMAIL PROTECTED]
> > CREATE TABLE Allan (DateTimeField DateTime); > > INSERT INTO Allan (DateTimeField) VALUES ('2004-01-04 12:00:00'); > > SELECT DateTimeField FROM Allan WHERE datetime(DateTimeField) = > > datetime('2004-01-04 12:00:00'); > > SELECT DateTimeField FROM Allan WHERE datetime(DateTime

Re: [sqlite] Date and Time functions are experimental

2004-01-05 Thread Doug Currie
Here are some clarifications about date and time functions. SQLite stores everything in the database as a string. You may choose to represent your datetimes in the database as Julian dates or as datetime formatted strings. Julian dates are doubles, but they are converted to and from string when wr

RE: [sqlite] Documentation

2004-01-05 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 06/01/2004 08:34 AM - Ben Carlyle 06/01/2004 08:31 AM To: "Allan Edwards" <[EMAIL PROTECTED]>@CORP cc: Subject:RE: [sqlite] Documentation Hello, "Allan Edwards" <[EMAIL PROTECTED]> 06/01/2004 12:18 AM

[sqlite] Question on column headers

2004-01-05 Thread SQLite Admin Support
This might be a no-brainer but I'll ask anyway. When creating a table is it proper to allow column names with spaces in them .. ie: my Column Steven - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [

Re: [sqlite] Date and Time functions are experimental

2004-01-05 Thread D. Richard Hipp
Kurt Welgehausen wrote: DRH wrote The date and time functions ... are fully tested ... I'm using SQLite version 2.8.8, precompiled binaries, on Linux. The date/time functions seem to work, but some of the modifiers don't. Specifically, 'gregorian', 'julian', 'start of week', 'localtime', and 'ut

Re: [sqlite] Date and Time functions are experimental

2004-01-05 Thread Kurt Welgehausen
DRH wrote >> The date and time functions ... are fully tested ... I'm using SQLite version 2.8.8, precompiled binaries, on Linux. The date/time functions seem to work, but some of the modifiers don't. Specifically, 'gregorian', 'julian', 'start of week', 'localtime', and 'utc' all cause the funct

Re: [sqlite] Date and Time functions are experimental

2004-01-05 Thread Roger Reghin
Got it!! =) Thank you so much again!! Roger. - Original Message - From: W Allan Edwards To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 12:53 PM Subject: Re: [sqlite] Date and Time functions are experimental By my understanding of the code, it is turing into into a

[sqlite] Btree API

2004-01-05 Thread Avner Levy
Hi, Is there any examples of the btree APIs ? Is the feature of the row_id (unique incremental number) exists in this API level as well ? I want to implement a queue (on disk) and I thought to use the btree with an incremental number field as the key. Any thoughs or comments will be appreciated..

Re: [sqlite] Date and Time functions are experimental

2004-01-05 Thread Roger Reghin
Understood!! Now, let me ask you something else about this subject... When comparing values, does SQLite transform the DateTime value to a string before comparing? For example, as Allan wrote: SELECT DateTimeField FROM Allan WHERE datetime(DateTimeField) = datetime('2004-01-04 12:00:00'); So

Re: [sqlite] DBD::SQLite SQL logic error on ATTACH

2004-01-05 Thread Matt Sergeant
On 31 Dec 2003, at 12:33, David Morel wrote: $dbh = DBI->connect("DBI:SQLite:/var/db/INSPIRON.primaire.sql"); $dbh->do( "ATTACH '/var/db/INSPIRON.secondaire.sql' AS secondaire ;" ); of course, the very same command succeed when typed in sqlite Is this a bug or am I doing something wrong ? Possibl

[sqlite] Date and Time functions are experimental

2004-01-05 Thread D. Richard Hipp
Allan Edwards wrote: I looked through the source code and those functions "WERE" experimental. They appear to be a full non experimental in the sqlite source code at this point. Thus far I have not found any problems with them. You can #define them out on a compilation if you don't want date rout

[sqlite] Question for the Dr. on Dates!

2004-01-05 Thread Allan Edwards
One thing I was unable to determine with my datetime fun in the past weeks was whether it was possible to stuff a date like this 12/23/2003 22:10:01 PM into a column in sqlite and then run a function to convert that date to a sqlite understood date for manipulation in a select WHERE clause. If thi

Re: [sqlite] Documentation

2004-01-05 Thread Roger Reghin
Great!! Thanks!! =) - Original Message - From: "Allan Edwards" <[EMAIL PROTECTED]> To: "'Roger Reghin'" <[EMAIL PROTECTED]>; "'D. Richard Hipp'" <[EMAIL PROTECTED]> Cc: "'SQLite Mailingliste'" <[EMAIL PROTECTED]> Sent: Monday, January 05, 2004 11:21 AM Subject: RE: [sqlite] Documentatio

RE: [sqlite] Documentation

2004-01-05 Thread Allan Edwards
I looked through the source code and those functions "WERE" experimental. They appear to be a full non experimental in the sqlite source code at this point. Thus far I have not found any problems with them. You can #define them out on a compilation if you don't want date routines, but they look t

RE: [sqlite] Documentation

2004-01-05 Thread Allan Edwards
Yeah, I went through this myself a couple of weeks ago. Your best bet is to store your dates like this, -MM-DD HH:MM:SS. The data adapter for .NET we are shipping over here allows you to write code for any other database via a data adapter, then port your code with few to no changes. We hav

Re: [sqlite] Documentation

2004-01-05 Thread Roger Reghin
drh, shouldn't it be listed on "Wiki Index"? Are those date functions yet experimental? BTW, I've found the "encode" functions at the FAQ...sorry for asking before trying everything... =) Thank you!! Roger. - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: "Roger

Re: [sqlite] Documentation

2004-01-05 Thread D. Richard Hipp
Roger Reghin wrote: Dear SQLite Friends, I can't find the documentation for the (yet experimental) DATE functions...where can I find it? http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 --

[sqlite] Java wrapper

2004-01-05 Thread Tim Anderson
I'd like to hear from users of the Java wrapper at http://www.ch-werner.de/javasqlite/. It is marked as "experimental" but as far as I know is the only Java wrapper available. Has anyone any comments concerning the reliability of this wrapper or any other features or limitations? Or know of any o

Re: [sqlite] Documentation

2004-01-05 Thread Roger Reghin
Thank you!!! =))) - Original Message - From: "Kurt Welgehausen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 05, 2004 10:05 AM Subject: Re: [sqlite] Documentation > > > ---

Re: [sqlite] Documentation

2004-01-05 Thread Kurt Welgehausen
- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Documentation

2004-01-05 Thread Roger Reghin
Thank you just the same =) - Original Message - From: "Ralph Wetzel" <[EMAIL PROTECTED]> To: "Roger Reghin" <[EMAIL PROTECTED]> Sent: Monday, January 05, 2004 8:08 AM Subject: Re: [sqlite] Documentation > Hi again! > > Sorry ... simple answer is no! :-) Haven't looked deeper in this to

Re: [sqlite] Documentation

2004-01-05 Thread Roger Reghin
Thank you so much!! =) Do you know anything about the DATE functions? []'s Roger. - Original Message - From: "Ralph Wetzel" <[EMAIL PROTECTED]> To: "Roger Reghin" <[EMAIL PROTECTED]> Sent: Monday, January 05, 2004 8:04 AM Subject: Re: [sqlite] Documentation > Good Morning! > > > Als

Re: [sqlite] Documentation

2004-01-05 Thread Ralph Wetzel
Good Morning! > Also, I heard somebody also saying something about "sqlite_encode_binary", > but couldn't find anything about that as well... The FAQ, Question 12, talks about BLOBs and the use of "sqlite_encode_binary". The function itself can be found in "encode.c", that is, as stated before, n

[sqlite] Documentation

2004-01-05 Thread Roger Reghin
Dear SQLite Friends, I can't find the documentation for the (yet experimental) DATE functions...where can I find it? Also, I heard somebody also saying something about "sqlite_encode_binary", but couldn't find anything about that as well... Thank you!! =) Roger Reghin ---