Let me paste a more detailed query, I am now realizing that I needed to put
more online...
I am testing on MS SQL Server, but want it to be generic enough to work with
Oracle and others if possible.
<cfquery datasource="#prefs.dsn#" name="header">
select h.id, h.header, f.state, f.sort, l.link, l.link_title
from headers h, fusion f, link l
f.sub_object = l.headerid
where f.owner = '#prefs.indexid#'
and f.sub_object = h.id
group by h.header, f.state, f.sort, l.link, l.link_title, h.id
</cfquery>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
