[duesi]

Hm,
aren't you guys kind of mimicking a DB anyway?
Why aren't you using some kind of light-weight DB like SqLite or something?

[9999]

Thanks alot nico. Sorry, I've been away the last couple of days. The search appears to be working PERFECTLY as all values are returned. The only problem is the month, day, and year don't match the record being pulled (which means the sorting is off). In fact, most of them say December 31, 1969.

One thing that I didn't make clear was the fact that the dates in the database are in the form August 24, 2006 which is the F j Y form I believe. Could this cause the problem?

Thanks

[Nico]

Could you maybe post some lines of the file? How exactly is the date stored?

Like this:
August|24|2006|Tip of the day...

???

I tested it with the example in your other thread and it worked for me.

EDIT:

But as Duesi said, I'd recommend using a database instead.

[9999]

Looks like you've got it. Unfortunately, I don't have the file on this machine but I am using "dummy" data like this:

Code:

July|19|2006|Sample text "Sample text Sample text" Sample text Sample text 07-19-2006
May|7|1706|Sample text Sample text Sample text Sample text Sample text 05-07-1706
February|29|1961|Sample text Sample text 'Sample text' Sample text Sample text 02-29-1961
October|26|1995|Sample text "Sample text Sample text" Sample text Sample text 10-26-1995
April|5|1836|Sample text Sample text Sample text Sample text Sample text 04-05-1836
July|11|1954|Sample text Sample text 'Sample text' Sample text Sample text 07-11-1954
October|1|2000|Sample text Sample text Sample text Sample text Sample text 10-01-2000

Each field is seperated by a "|" with a hard return after each line/record. In my test file I have over a thousand records. At the end of each line I put the date like this"07-11-1954" so I could compare it to the the month, day, and year fields associated with it "July|11|1954|"

I also used a variety of years because in the future, the database might contain historical references.

LOL a database would probably have been much easier, but at the time I started, I just went with what I had some knowledge of.

Originally Posted by nico_swd

Could you maybe post some lines of the file? How exactly is the date stored?

Like this:
August|24|2006|Tip of the day...

???

I tested it with the example in your other thread and it worked for me.

EDIT:

But as Duesi said, I'd recommend using a database instead.

[9999]

Nico, you were right, it does work and I found out what causing the errors. Some of the records I used contained values before the epoch (January/1/1970) and that is causing the script to return December 31, 1969 for all of those records.

So my question is, is there any way to get around this so that values pre 1970 would work?