I am trying to fix a bug that I can see, just not sure how to get it to work correctly.
I have 2 tables joined one holds information regarding a room, and the second holds seasonality dates. So if I have the following to run a query on: Start Date: 31-Oct-2007 End Date: 10-Nov-2007 The seasonality table has 2 rows Season1 Start: 1-Oct-2007 Season1 End:31-Oct-2007 Price1: $100.00 Season2 Start: 1-Nov-2007 Season2 End:31-Dec-2007 Price2:$200.00 Now the current query returns 2 records one with number of days @ $100 and number of days @ $200, the client is needing that these get totalled so that if there is 1 @ $100 and 9 @ $200 then it becomes a total of $1900. Does this makes sense? It is driving me insane let me tell youJ Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. <http://www.aegeon.com.au> www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2961 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
