macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

Re: Query of Queries on 2 datasources

Subject: Re: Query of Queries on 2 datasources
From: "MIGhunter"
Date: Sat, 21 Feb 2009 00:23:15 +0000 UTC
Newsgroups: macromedia.coldfusion.advanced_techniques

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:


 <!--- Adding points from point page --->
 <CFQUERY NAME="allPoints" DATASOURCE="einherjarsat" username="" password="">
 SELECT * 
 FROM eqdkp_members
 ORDER BY member_name
 </CFQUERY>

 <CFQUERY NAME="allNames" DATASOURCE="botd_2008" username="" password="">
 SELECT * 
 FROM einherjar_priorities
 ORDER BY user_name
 </CFQUERY>

 <cfquery name="combinedNames" dbtype="query">
 SELECT * 
 from allPoints, allNames 
 where allNames.user_name = allPoints.member_name
 </cfquery>

 <cfoutput query="combinedNames" startrow="#pagination.getStartRow()#" 
maxrows="#pagination.getMaxRows()#">
 <!--- End of point page query --->
        
                <tr>
                        <!--- User name --->
                        <td align="left"><font color="Blue" 
size=""><b>#user_name#</b></font></td>
                        <td><font color="" 
size="">#combinedNames.member_earned#</font></td>
                        <td><font color="" size="">#ReplaceNoCase(CP1,"None"," 
","all")#</font></td>
                        <td><font color="" size="">#ReplaceNoCase(CP2,"None"," 
","all")#</font></td>
                        <td><font color="" size="">#ReplaceNoCase(OP1,"None"," 
","all")#</font></td>
                        <td><font color="" size="">#ReplaceNoCase(OP2,"None"," 
","all")#</font></td>
                        <td valign="bottom"><font color="gray" 
size="-2">#DateFormat(dated_on, 
"mm/dd/yyyy")# at #DateFormat(dated_on, "hh:mm:ss")#</font></td>
                </tr>

        </cfoutput>


<Prev in Thread] Current Thread [Next in Thread>