[sqlite] Scour.com invite from harish

Hey, Did you hear about Scour? It is the next gen search engine with Google/Yahoo/MSN results and user comments all on one page. Best of all we get paid for using it by earning points with every search, comment and vote. The points are redeemable for Visa gift cards! It's like earning credit

[sqlite] Scour.com invite from harish

Hey, Did you hear about Scour? It is the next gen search engine with Google/Yahoo/MSN results and user comments all on one page. Best of all we get paid for using it by earning points with every search, comment and vote. The points are redeemable for Visa gift cards! It's like earning credit

Re: [sqlite] Help with BLOBs

On Jul 17, 2008, at 10:47 AM, Nolan Darilek wrote: > Hello. I'm trying to add BLOB support to a Ruby interface to > SQLite3 and > am running into an issue. I've created a column of type BLOB and am > writing ruby strings of binary data, but it seems like sqlite might be > null-terminating

[sqlite] Help with BLOBs

Hello. I'm trying to add BLOB support to a Ruby interface to SQLite3 and am running into an issue. I've created a column of type BLOB and am writing ruby strings of binary data, but it seems like sqlite might be null-terminating these strings. Specifically, when I check the length of the

Re: [sqlite] ANN: SQLite .NET provider updated

wow, can i nominate you for sainthood?  i mean really!  i was trying to use esql and its a mess...ug!   thanks!   Woody --- On Wed, 7/16/08, Robert Simpson <[EMAIL PROTECTED]> wrote: From: Robert Simpson <[EMAIL PROTECTED]> Subject: Re: [sqlite] ANN: SQLite .NET provider updated To:

Re: [sqlite] ANN: SQLite .NET provider updated

Sure does! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harold Wood Sent: Wednesday, July 16, 2008 7:20 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] ANN: SQLite .NET provider updated very very cool!  now does it work with teh

Re: [sqlite] ANN: SQLite .NET provider updated

very very cool!  now does it work with teh compact framework? --- On Wed, 7/16/08, Robert Simpson <[EMAIL PROTECTED]> wrote: From: Robert Simpson <[EMAIL PROTECTED]> Subject: [sqlite] ANN: SQLite .NET provider updated To: "'General Discussion of SQLite Database'" Date:

[sqlite] ANN: SQLite .NET provider updated

I don't normally announce releases here, but this one's got some great stuff in it. Those of you using the SQLite ADO.NET provider will want to check out. Some highlights in the 52 release: 3.6.0 code merge Table and View designers - you can now create and design tables and views, indexes and

Re: [sqlite] Issuing command for bulk import

Fantastic - thank you so much for this - I will try both options - funny I was considering using a transaction. Thanks so much. Celeste. Dennis Cote wrote: > > gtxy20 wrote: >> >> I can't help but think that the separator is not being escaped properly >> to >> indicate a tab - I have tried

Re: [sqlite] Issuing command for bulk import

gtxy20 wrote: > > I can't help but think that the separator is not being escaped properly to > indicate a tab - I have tried \t, \\t, "\t", '\t' but no luck. > For some reason the -separator option on the command line always sets the separator string to \\t (i.e. the literal string entered on

Re: [sqlite] Issuing command for bulk import

If it helps I am using sqlite 3.5.9 - I have tried the following and this works: sqlite3 test.db sqlite> .separator "\t" sqlite> .import data.txt test C. gtxy20 wrote: > > Yes it indicates line 1 - I have checked to make sure that all rows are in > fact tab delimited and that there are no

Re: [sqlite] Issuing command for bulk import

Yes it indicates line 1 - I have checked to make sure that all rows are in fact tab delimited and that there are no blank trailing lines in the data. The error: data.txt line 1: expected 2 columns of data but found 1 - keeps being thrown. I have tried both under windows and linux and the

Re: [sqlite] Issuing command for bulk import

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Woodbridge Sent: Wednesday, July 16, 2008 6:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Issuing command for bulk import gtxy20 wrote: > Hi, > > I the following commands

[sqlite] Issuing command for bulk import

Hi, I the following commands from my application to bulk import data from a tab delimited text file (over 5 million records). -separator "\t" test.db ".import data.txt testtable" -separator \t test.db ".import data.txt testtable" but I keep getting the following error - expected 2 columns of