If I want to order by dateAdded to I have to include it in the select statement like

If I do this:

<cfquery name="chart" datasource="#datasource#">
select behaviourID,score, dateAdded2 = convert(varchar, dateAdded , 101)
from staff_charts_data

where userID =
<cfqueryparam value="#arguments.userID#" cfsqltype="cf_sql_integer"> AND
NOT score = 5
</cfquery>

If I want to order by dateAdded to I have to include it in the select statement like so:

<cfquery name="chart" datasource="#datasource#">
select behaviourID,score, dateAdded2 = convert(varchar, dateAdded , 101),dateAdded
from staff_charts_data

where userID =
<cfqueryparam value="#arguments.userID#" cfsqltype="cf_sql_integer"> AND
NOT score = 5
</cfquery>