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? xn
