Re: [sqlite] NULL popping up in INSERTed strings

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

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

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

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

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

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...

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

>> ... 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

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

> > 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

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

- 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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Documentation

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

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

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

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 ---