I believe I need all those columns and more. The grouping on cfoutput didn't
work, I suppose, cause there's unique data in each record and none of them are
truly the same. That's why there's 4 records to begin.
I suppose I could do three seperate queries and that would work for this case.
It seems convoluted to me, too. But, I'm having a hard time wrapping
my head around what you want to accomplish. It looks like you're
grouping on a non-unique field, which will of course give you multiple
results. You should be doing the cfoutput group on the n_r_id field, I
would think, if you
Daniel,
You need to look at your database requirements from an output point of view.
What I mean is this.
If I want to return data from Table A and the row from Table B that is
matched by a priamry field then I should be looking at inner join. And of
course it is either left or right depending
It's a unique field. It's the ID field of the attendees table, which relates
to the notes or the base table. But since the other fields don't all have
the same data from there, I suppose it can't logically group. For example,
they might each have different values in the take_aways field.
I
You know, you might have an ordering issue. The cf group by needs the
query to be ordered by whatever you're grouping by for it to work
correctly. Have you tried ordering it by that id?
On 11/3/06, daniel kessler [EMAIL PROTECTED] wrote:
It's a unique field. It's the ID field of the attendees
I don't completely follow what you're saying because of my db inexperience.
Nonetheless, I'm think that there's not a cure because it's a many to one
relationship. There are attendees and several take_aways per note (my base
table). To represent them as one record, I'd have to have an array
I have not and didn't know that - thanks for the information. In that case,
for three orderings, I'd need to do three queries, right?
You know, you might have an ordering issue. The cf group by needs the
query to be ordered by whatever you're grouping by for it to work
correctly. Have you tried
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
I have not and didn't know that - thanks for the information.
In that case, for three orderings, I'd need to do three
queries, right?
You know, you might have an ordering issue. The cf group by needs the
query
Give us an example of what you want the output to look like, and we
may have a better chance of figuring out what you need to do.
On 11/3/06, daniel kessler [EMAIL PROTECTED] wrote:
I have not and didn't know that - thanks for the information. In that case,
for three orderings, I'd need to do
How many of the columns are needed? If you only need a fw of the columns,
remove the extra columns and then loop over them regularily. If you want to
group them, then use the group attribute in cfoutput, which isn't all that
cumbersome at all. If you have duplicates, just make sure to use the
10 matches
Mail list logo