On Sunday, Oct 12, 2003, at 23:04 Europe/Amsterdam, Christian G. Warden
wrote:
On Sun, Oct 12, 2003 at 10:45:04PM +0200, Ilja Booij wrote:
On Friday, Oct 10, 2003, at 22:23 Europe/Amsterdam, Christian G.
Warden
wrote:
db_get_main_header() retrieves all of the messageblks. Shouldn't
there
be a LIMIT 1 in the query?
LIMIT is not valid SQL-92 as far as I know, which would make it
difficult
or impossible to use the same code using another RDBMS (Oracle for
instance)
But it is getting too many rows, right? Perhaps a select_limit
function
should be written for each sql driver. Or, even easier, why not add a
header flag to the messageblks table?
I've rewritten the query to only return the lowest messageblk_idnr for
a message using select min(messageblk_idnr).. etc
the update is in CVS (2.0 branch)
Ilja
--
IC&S
Koningsweg 4
3582 GE UTRECHT
