Re^3: Lotus Notes date ranges not returning all documents

Thanks for the links.

Having looked at them I now remember why I gave up on OLE: reading a few thousand pages of docs for a small script was not really worth the effort then.

If you are interested to have a look at the ODBC connector, called "NotesSQL": you can find it here.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Comment on Re^3: Lotus Notes date ranges not returning all documents

Replies are listed 'Best First'.
Re^4: Lotus Notes date ranges not returning all documents by runrig (Abbot) on Feb 24, 2009 at 16:59 UTC
Thanks, found it, installed it. Works great. Seems faster than the OLE interface also. Whoever designed the database left many of the columns in the views with their default names, so I end up with queries like this: `select * from "By Start Date" where _42 between '2009-04-01' and '2009-04-17'` [download] But hey, it works :-)	[reply] [d/l]
Re^4: Lotus Notes date ranges not returning all documents by runrig (Abbot) on Feb 24, 2009 at 17:32 UTC
Ahh, I do have an issue with the NotesSQL. The requirement that started this was to find all documents after a certain date that had a certain field empty. The field was a rich text field, and NoteSQL only returns the text part of the field, but rich text fields can contain attachments/embedded objects. So, although NoteSQL looks like it'll be useful in the future, for now, it's back to OLE for me (and I just have to scan through all documents instead of trying to use GetAllEntriesByKey() with the "by date" view) :-(	[reply]