Re: [sqlite] A suggestion

2007-05-11 Thread jphillip
Doskey was the history TSR. On Wed, 9 May 2007, Rich Shepard wrote: > On Wed, 9 May 2007, John Stanton wrote: > > > That program does have the capability, but may not be implemented that way > > on Windows. Why not make the change yourself? > > > > A.J.Millan wrote: > > > As a suggestion, and

[sqlite] Re: SPAM-LOW: [sqlite] Re: Changing order - why??

2006-11-13 Thread jphillip
On Sun, 12 Nov 2006, Igor Tandetnik wrote: > Ralph Wetzel <[EMAIL PROTECTED]> wrote: > > might it be possible, that someone explains, why anyone would put > > effort in this task? Aren't databases designed to keep data in whatever > > order... :-? > > Imagine you want to store playlists in the

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread jphillip
.help pretty well sums it up. On Tue, 19 Dec 2006, Anderson, James H (IT) wrote: > How do I find doc on .import? > > Is there a way to specify the delimiter for the CSV file? > > Thanks, > > jim > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent:

RE: [sqlite] Is there a method for doing bulk insertion?

2006-12-19 Thread jphillip
way to use a delimiter other than a > comma to import a CSV file? > > -Original Message----- > From: jphillip [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 19, 2006 3:47 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Is there a method for doing bulk insertion?

[sqlite] Re: SPAM-LOW: RE: [sqlite] Format of csv file RE: [sqlite] date/time implementation question

2007-03-15 Thread jphillip
I use the tilde '~' character a lot. On Thu, 15 Mar 2007, Griggs, Donald wrote: > Regarding: "What is the default separator?" [for using with .import in > the command line utility] > > It is the vertical bar ("|", virgule, pipe character). > > By the way, I don't *think* that .import allows

Re: [sqlite] Issue with trailing blanks

2007-03-27 Thread jphillip
Perl does pretty slick work on CSV type files. On Mon, 26 Mar 2007, Joel Cochran wrote: > Hi Puneet, > > I probably shouldn't have said that they 'ignore' the blanks, but they are > capable of treating them as white space for text matching purposes. I can't > speak for Oracle, but I'm pretty