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
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
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
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
4 matches
Mail list logo