[Reactor for CF] New to reactor and Curious how to do this

[Andrew Scott]

Ok I have a components table, that can be any number of different types and has a separate table here is a query which I would like to see if I can get into reactor.                                       select                                                 dbo.BookingOptions.OptionsId, dbo.BookingOptions.BO_ID, dbo.BookingOptions.BI_ID, dbo.BookingOptions.BookingOrder,                                                 dbo.BookingOptions.BookingOption, dbo.BookingOptions.OptionInvoiced, dbo.BookingOptions.IsConfirmed, dbo.BookingItems.BI_ParentItem, dbo.BookingItems.BI_Order,                                                 dbo.BookingItems.BI_Type, dbo.BookingItems.BI_Status, dbo.BookingItems.BI_Component, dbo.BookingItems.BI_StartDate,                                                 dbo.BookingItems.BI_Days, dbo.BookingItems.BI_DeptPort, dbo.BookingItems.BI_DestPort, dbo.BookingItems.BI_NettPrice,                                                 dbo.BookingItems.BI_Price, dbo.BookingItems.BI_Currency, dbo.BookingItems.BI_CurRate, dbo.BookingItems.BI_Commision,                                                 dbo.BookingItems.BI_Tax, dbo.BookingItems.BI_Markup, dbo.BookingItems.BI_Credit, dbo.BookingItems.BI_GSTApplies, dbo.BookingItems.BI_Qty,                                                 dbo.BookingItems.BI_isPackage, dbo.BookingItems.BI_enterDate, dbo.BookingItems.BI_requestDate, dbo.BookingItems.BI_ConfDate,                                                 dbo.BookingItems.BI_Notes, dbo.BookingItems.BI_ConfNo, dbo.BookingItems.BI_Details, dbo.BookingItems.BI_BookingOrder,                                                 dbo.BookingItems.BI_IsConfirmed                                     from                                                 dbo.Bookings                                     inner join                                                 dbo.BookingOptions on dbo.Bookings.BO_ID = dbo.BookingOptions.BO_ID                                     inner join                                                 dbo.BookingItems on dbo.BookingOptions.BI_ID = dbo.BookingItems.BI_ID                                     where                                                 dbo.BookingOptions.BO_ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#arguments.id#" />                                     <cfif Client.BookingType eq "BO">                                                 and BookingOptions.IsConfirmed = 1                                     </cfif>                                     order by                                                 BookingOption, BookingOrder, BI_TYPE, BI_Order   Now the problem lies with BI_Component, how can I tell this to read from any number of tables, for example flightComponents, or TourComponents.   And the relationship is between these two is BI_Component for about 10 more tables.   Any ideas?     Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  8676 4223 Mobile: 0404 998 273   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --