Remember a view can contain data which is in the underlying tables in a different form (even new data not in them), It could contain computed fields, sums across many fields, new columns so in that way a view can contain unique data.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Deanna Schneider To: CF-Talk Sent: Tue Jan 23 13:05:37 2007 Subject: Re: Do I use a view for this? I'm confused. A view is nothing more than a saved query, really. A view isn't going to "store" unique data. (Well, you can use a view with triggers to update underlying tables, but I don't think that's what you're trying to do.) If it were me, I'd be storing the non-calculated data in the database. I'm not quite sure what "extended price" is - but if it's simply the total (amount sold X price), then you shouldn't need to store that. You should store the amount sold and the price in the DB. You can write a view then that simply calculates that for you, so you don't have to write the query over and over, but it's really nothing more than writing the query once and running it with: create or replace myview AS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
