Hello I am working on a query where I am trying to SELECT a record using the IN() function:

Code:
<cfquery name="getAddresses" datasource="#application.datasource#">
	SELECT ID, COMP_NAME, ADDRESS1_1, CITY1, STATE1, ZIP1, PHONE1_1, FAX1_1, CATEGORY
	FROM Vendors
	WHERE #id# IN (CATEGORY)
	ORDER BY COMP_NAME
</cfquery>
id is a cfparam passed in on the url and...