The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
<!--- retrieve all alpha's from the db --->
<cfquery name="Assignments" datasource="shs">
SELECT COUNT(LEFT(status,1)) AS AlphaCnt, LEFT(status,1) AS Alpha
FROM tblAssignment
GROUP BY LEFT(status,1)
ORDER BY LEFT(status,1) ASC
</cfquery>
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
Open in new window