|
|
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>
|
|