Re: Flatten out a relational database

2008-01-24 Thread Dominic Watson
May I be so pertinant as to ask why it must be so? i.e. it may be more efficient and easier to read to do that bit in ColdFusion. So get the query to return like: permit info,company1 permit info,company2 Then, if you were outputting to excel for example, do: tr cfoutput query=thequery

Re: Flatten out a relational database

2008-01-24 Thread Claude Schneegans
I don't just want: permit info,company1 permit info,company2 Why not? If you use the GROUP attribute in CFOUTPUT, you can make your query really look like Permit Info 1-Company1 2-Company2 -- ___ REUSE CODE! Use custom tags; See

Flatten out a relational database

2008-01-23 Thread David Mineer
I need a query that will flattion out a relational database. I have 2 objects. Permits and Companies. Right now you enter a permit, then you can add 1-n companies and attach them to that permit. A query would return Permit Info 1-Company1 2-Company2 etc... I want to return Permit

Re: Flatten out a relational database

2008-01-23 Thread C. Hatton Humphrey
It's not a simple join that you're looking for. You'll need to make use of an index and temporary table. What is the database engine you're using for this? Hatton On Jan 23, 2008 7:35 PM, David Mineer [EMAIL PROTECTED] wrote: I need a query that will flattion out a relational database. I