it could be that the previous query is stored in a session.
Close the browser completely to end the session between tests.
to troubleshoot, change:
<cfquery name="WADAdbotblApplicationScores" datasource="csf">
SELECT TOP (100) PERCENT dbo.tblApplicationScores.applicationScoreID, dbo.tblApplicationScores.applicationID, dbo.tblApplicationScores.scorerID,
dbo.tblApplicationScores.plScore, dbo.tblApplicationScores.siScore, dbo.tblApplicationScores.ciScore, dbo.tblApplicationScores.lorScore,
dbo.tblApplicationScores.scorerNotes, dbo.tblApplicationScores.totalScore, dbo.tblApplicationScores.scoringGroupID, dbo.tblApplicationScores.scholarshipYear,
dbo.tblScoringGroups.scoringGroup, dbo.tblApplications.applicantID, dbo.tblApplicants.first_name, dbo.tblApplicants.last_name, dbo.users.Fname AS scorerFname,
dbo.users.Lname AS scorerLname
FROM dbo.tblApplicationScores INNER JOIN
dbo.tblScoringGroups ON dbo.tblApplicationScores.scoringGroupID = dbo.tblScoringGroups.scoringGroupID INNER JOIN
dbo.tblApplications ON dbo.tblApplicationScores.applicationID = dbo.tblApplications.applicationID INNER JOIN
dbo.tblApplicants ON dbo.tblApplications.applicantID = dbo.tblApplicants.applicantID INNER JOIN
dbo.users ON dbo.tblApplicationScores.scorerID = dbo.users.userID
#PreserveSingleQuotes(WADbSearch1.whereClause)#
#PreserveSingleQuotes(WADA_Sort_1.FinalOrderClause)#
</cfquery>
to:
<cfoutput>
SELECT TOP (100) PERCENT dbo.tblApplicationScores.applicationScoreID, dbo.tblApplicationScores.applicationID, dbo.tblApplicationScores.scorerID,
dbo.tblApplicationScores.plScore, dbo.tblApplicationScores.siScore, dbo.tblApplicationScores.ciScore, dbo.tblApplicationScores.lorScore,
dbo.tblApplicationScores.scorerNotes, dbo.tblApplicationScores.totalScore, dbo.tblApplicationScores.scoringGroupID, dbo.tblApplicationScores.scholarshipYear,
dbo.tblScoringGroups.scoringGroup, dbo.tblApplications.applicantID, dbo.tblApplicants.first_name, dbo.tblApplicants.last_name, dbo.users.Fname AS scorerFname,
dbo.users.Lname AS scorerLname
FROM dbo.tblApplicationScores INNER JOIN
dbo.tblScoringGroups ON dbo.tblApplicationScores.scoringGroupID = dbo.tblScoringGroups.scoringGroupID INNER JOIN
dbo.tblApplications ON dbo.tblApplicationScores.applicationID = dbo.tblApplications.applicationID INNER JOIN
dbo.tblApplicants ON dbo.tblApplications.applicantID = dbo.tblApplicants.applicantID INNER JOIN
dbo.users ON dbo.tblApplicationScores.scorerID = dbo.users.userID
#PreserveSingleQuotes(WADbSearch1.whereClause)#
#PreserveSingleQuotes(WADA_Sort_1.FinalOrderClause)#
</cfoutput>
then add:
<cfabort>
just before the doctype tag
post back the entire query that is written the the screen and the latest copy of your page.