Your question, your audience. Choose who sees your identity—and your question—with question security.
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.
_agx_ pointed out my value for cfsql was wrong:
Here's the correct code:
<CFQUERY NAME="DisplayCVITool" datasource="Actuaries" username="#application.use
SELECT users.firstName
,users.lastname
,users.id_number
,cvitool.CMTEE_PREF
FROM users,
cvitool
WHERE users.user_id=cvitool.id
AND users.user_id = <cfqueryparam cfsqltype="CF_SQL_INTEGER"
</CFQUERY>