This content has been marked as final. Show 8 replies
MIGhunter wrote:1 person found this helpful
> FROM what goes here?
Since this is a query of queries, the names of the queries go there.
FROM dsA, dsB
WHERE user_name = member_name
The ValueList() function would probably come in handy here. Usage is described in the cfml reference manual. If you don't have one, the internet does.
You could try the same pinciple/idea of what I posted in thread http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=1&catid=7
Copied/Pasted from that thread:
You could read thru the first query and add the contents to a temp query assigning a sort by field and then read thru the second query and add it to the same temp query with a sort by field. Then do a query of that temp query.
This leads me to a new question.
How can I output my query in my current table without rewriting everything?
My original query is for the table and if I use the above code with #combinedNames.member_earned# the table is 1 number. Like this: Preview
It's the 2nd column. Now, If I break the cfoutput and put in a new cfoutput with the combined queries, it totally jacks up the table all over the page. Hope that makes sense.
Instead of breaking the query, try using, for column two (instead of a cfoutput) a1 person found this helpful
Unless I'm misunderstanding you.
I actually got it working using the combined query instead of 2 queries. The only problem is that if the player is organized and declares a priority before going to their 1st event, their name won't show up. Of course this shouldn't really matter since they have to participate before they can have a priority. Here is how I got it to work:
I didn't know you could do that. Thanks for teaching me something new!1 person found this helpful