cfoutput shows 0 instead of correct query data
On my testing server, everything works fine. Exact same code and data. On the live server, ColdFusion displays 0 instead of correct values. Please see below.
RESULTS on my computer:
Division 1 TAHSXxxxxxx, Daniel Xxxxx@gmail.com Paid: 45.00 Division: 1 Division 2 SCHSXxxxxx, Deborah Xxxxx@gmail.com Paid: 45.00 Division: 2 Division 3 DHSXxxxxx, StevePaid: 45.00 Division: 3WDHS Xxxxxx, Val Xxxxx@gmail.com Paid: 50.00 Division: 3 |
Results on Live Server:
Division 1 TAHS Xxxxxxx, Daniel Paid: 45.00 Division: 0 Division 0 SCHS Xxxxxxx, Deborah Paid: 45.00 Division: 0 DHS Xxxxxx, Steve Paid: 45.00 Division: 0 WDHSXxxxxx, Val Xxxxx@gmail.com Paid: 50.00 Division: 0 |
My Query:
<cfquery name="get_nominees" datasource="xxxxx" username="xxxxx" password="xxxxx">
SELECT confirmed, academic_team_id, last_name, first_name, email, paid, division ,name
FROM academic_teams, coaches, schools
WHERE academic_teams.coach_id=coaches.coach_id
AND academic_teams.school_id=schools.school_id
ORDER BY division, name
</cfquery>
My CFOUTPUT:
<cfoutput query="get_nominees" group="division">
<div style="font-weight:bold; background-color:##CCCCCC; width:300px;">Division #division#</div>
<cfoutput>
<strong>#name#</strong><br />
#last_name#, #first_name#<br />
#email#<br />
Paid: #paid# <br />
Division: #division#<br /><br />
</cfoutput>
</cfoutput>
My DATA
| "confirmed" | "academic_team_id" | "last_name" | "first_name" | "email" | "paid" | "division" | "name" |
| "0" | "3" | "Xxxxxx" | "Daniel" | "Xxxxx@gmail.com" | "45.00" | "1" | "TAHS" |
| "1" | "4" | "Xxxxxx" | "Deborah" | "Xxxxx@gmail.com" | "45.00" | "2" | "SCHS" |
| "0" | "5" | "Xxxxxx" | "Steve" | "Xxxxx@gmail.com" | "45.00" | "3" | "DHS" |
| "0" | "6" | "Xxxxxx" | "Val" | "Xxxxx@gmail.com" | "50.00" | "3" | "WDHS" |
Any help would be greatly appreciated.
AdChoices