Re: [sqlite] null handling import

2011-08-12 Thread H. Phil Duby
On Fri, Aug 12, 2011 at 14:59, matthew (matthew.jsoft) white wrote: > > This may seem obvious for seasoned users, but sqlite3 always turns every > blank input token into an empty string. > > For example, say you are dot.importing a colon separated file such as :- >

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

2011-07-11 Thread H. Phil Duby
On Sat, Jul 9, 2011 at 23:22, Stephan Beal wrote: > On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder > wrote: > > > sqlite db files and making sure that directory is writable by my web > > server. I make sure that the directory is not used for anything

Re: [sqlite] Request for help with SQLite Query to return missing Date/Time Ranges

2011-04-21 Thread H. Phil Duby
On Thu, Apr 21, 2011 at 12:57 AM, Oliver Peters wrote: > > Andrew Lindsay writes: > > [...] > > > I am trying to search an SQL database that is meant to have entries logged > > every minute for a period of approximately 15 months. > > > > I want to create a

Re: [sqlite] WebSql question

2011-03-18 Thread H. Phil Duby
Nothing to do with SQLite, but ... On Fri, Mar 18, 2011 at 4:01 AM, Matt Young wrote: > > Here is my Javascript code, it works.  Except I have to know the table field > names within the javascript code itself: This little phrase: > > results.rows[i].f1 > > f1 is a field

Re: [sqlite] Asymmetric keys encryption

2011-02-22 Thread H. Phil Duby
On Tue, Feb 22, 2011 at 9:07 AM, Philip Graham Willoughby wrote: > > On 22 Feb 2011, at 15:41, Max Vlasov wrote: > > The obvious solution is public-key cryptography. The question is about > > different ways how it could be implemented with sqlite. The

Re: [sqlite] RESOLVED: unable to open database file/Disc I/O error

2010-11-05 Thread H. Phil Duby
On Fri, Nov 5, 2010 at 3:25 AM, Serena Lien wrote: > > I would like to inform the group that I managed to resolve the issue with a > workaround. I am not sure if this is a bug in vista or whether there might > in fact be some slight issue with sqlite... > > The problem seems

Re: [sqlite] WAL file growth concern

2010-10-23 Thread H. Phil Duby
On Sat, Oct 23, 2010 at 9:26 AM, Bob Smith wrote: > On Sat, Oct 23, 2010 at 5:56 AM, Richard Hipp wrote: > > > > Is that what you are seeing? > > > > Which filesystem are you using? > > > > > > Thanks Richard, this does seem to be what I am seeing. I am definitely > seeing

Re: [sqlite] Null character problem

2010-07-09 Thread H. Phil Duby
On Fri, Jul 9, 2010 at 10:48 AM, Eric Smith wrote: > Will sqlite3_bind_text work properly if the string contains (internal) > nulls?  What if I did something like: > > char zText[100]; > memset(zText, 0, sizeof(zText)); > sqlite3_bind_text(stmt, idx, zText, sizeof(zText),

Re: [sqlite] CLOSED: PRAGMA table_info() with database name?

2010-05-09 Thread H. Phil Duby
On Sun, May 9, 2010 at 7:13 AM, Jay A. Kreibich wrote: > On Sun, May 09, 2010 at 01:57:12PM +0200, Oliver Lange scratched on the wall: > > Richard Hipp wrote: > > > > The correct syntax is: > > > > > >      PRAGMA main.table_info(mytable); > > > Aah, very nice. Just tried, works

[sqlite] dead link on sqlite-announce info page

2010-04-02 Thread H. Phil Duby
Hi All, I just subscribed to the announce mailing list. The welcome message includes a link to, which has a link to the sqlite-announce Archives. I get a 404 error for the page at

[sqlite] whitespace for multi-line block comment not completely eliminated

2010-04-02 Thread H. Phil Duby
Hi all, I seem to have found a bug, possibly related to and the linked checkin A 'C' style block comment that is not all on one line does not get ignored properly. If the line immediately after the