on 11/20/00 3:17 PM, Peter Theobald at [EMAIL PROTECTED] wrote:
> You could normalize your database and have all the common fields in one table
> "item".
> Only store the type specific data in the separate 'demos', 'movies', and
> 'patches' tables.
Too late for that, I'm afraid... the schema was not designed by me.
> If you can't change your schema at this point, you can select the newest 20
> items from each table into a temporary table and then select the (global)
> newest 20 from the temporary table.
Thanks, I'll try that.
--
Rob Keniger
big bang solutions
<mailto:[EMAIL PROTECTED]>
<http://www.bigbang.net.au>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists