>> The more I think about it, I might just not use the catalog at all. >> This isn't a 'search' mechanism anyway, so I think I'm going to >> replan this and go to the db directly.
We do something similar except it is to pull a list of video game map files - pulling random recent ones - and the with MSSQL the query is something like. SELECT Top 10 ID,. <data fields>. FROM thetable Where addeddate > #somedate# Order By NEW(ID) Ordering by New(ID) randomizes the selection within the bounds of the Where clause and the TOP X sets the limit of the records pulled. Dennis, Webmaster - www.halomaps.org .================================================. |Halo Maps Website - http://www.halomaps.org | |Halo Movies Website - http://www.halomovies.org | |Halo CE Chronicles - http://hcec.halomaps.org | .================================================. -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
