our data, sometimes the pipe or tab makes
> a better separator.
>
>
>
> -Original Message-
> From: Rafi Cohen [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 15, 2007 12:42 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Format of csv file RE: [sqlite] date/
2007 12:42 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Format of csv file RE: [sqlite] date/time
implementation question
Dennis, without knowing that we are talking here about non-standard
format of the csv file, my client, for whom I'm preparing this project
decided to change the
a success for me to implement this approach in my C
code as you suggested.
Thanks, Rafi.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2007 11:11 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Format lf csv file RE: [sqlite] date/time
impleme
oses. That way, you can close and come
back later to deal with the rows that crossed-over into past-date state.
-Clark
- Original Message
From: Rafi Cohen <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, March 14, 2007 1:21:21 PM
Subject: [sqlite] Format lf csv f
Rafi Cohen wrote:
Hi Dennis, the first approach is clear now and I may proceed with it.
Good to hear.
The second approach is interesting and chalenging, but leaves some
issues to clarify and in case I find solutions to those issues I well
may adopt it.
1. format of csv file: I have no idea h
nd approach.
Thanks, Rafi.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2007 9:15 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] date/time implementation question
Rafi Cohen wrote:
> Dennis, I really appreciate your patience and willingne
Rafi Cohen wrote:
Dennis, I really appreciate your patience and willingness to help.
Unfortunately, this still did not bring me to the expected solution. I
will give you a small algorithm of what I need to do and I'm sure after
this you'll know how to assist me.
1. I read a .csv file into a linke
t: Re: [sqlite] date/time implementation question
Rafi Cohen wrote:
> Thanks Denis for your detailed explanation. My needs differ from the
> example you gave. I need to compare the date on each row with the
> current date, if the rowdate has passed then I either insert or update
&
Rafi Cohen wrote:
Thanks Denis for your detailed explanation. My needs differ from the
example you gave.
I need to compare the date on each row with the current date, if the
rowdate has passed then I either insert or update this row on a specific
table, otherwise I leave this row for a future che
make this comparison?
Thanks, Rafi.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 7:15 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] date/time implementation question
Rafi Cohen wrote:
> Hi, I hope this question is not off-topic for thi
Rafi Cohen wrote:
Hi, I hope this question is not off-topic for this list.
I'm recieveing, occasionally, a .csv file from a source which I need to
process accordcing to some criteria and either insert, delet or update
it's rows into a database. One of it's criterias is date comparison.
In other w
Hi, I hope this question is not off-topic for this list.
I'm recieveing, occasionally, a .csv file from a source which I need to
process accordcing to some criteria and either insert, delet or update
it's rows into a database. One of it's criterias is date comparison.
In other words, proceeding dif
12 matches
Mail list logo
