Perhaps someone else a bit less lofty and more inclined to
assist rather than humiliate would be willing to assist.
Here is the bit of code as it stands:
<cfquery name="list" datasource="#dsnm#">
SELECT *
FROM students
where status = '#x#' and id in "#listqualify(select,"")#"
order by #sort_order# asc
</cfquery>
As stated above I've tried a number of different variations,
leaving out listqualify, with and w/o double quotes, with and w/o
single quotes, with and w/o parenthesis, etc., as well as using
text data instead of integers; I've even pruned out the criteria
for the leading AND statement. The code above generates the error
posted previously.
I appreciate the help.