Selecting Records based on DB column with list

[craigkaminsky]

Hi,

I am stuck (and I think this will end up being a duh/d'oh thing!). I have a
dbase table called projects (Access) that contains project data. One of the
columns in the dbase is "employee_list". This column contains a list of
integers that relate to each employee assigned to a given project.

When an employee logs into the system to record their time, they are (should
be) presented with a list of projects currently assigned to them (often,
multiple employees are assigned to each project). What I need to do, as each
employee's logon is processed, is find all projects assigned to an employee.

I want to search the employee_list column to see if the id of the employee
signing in is in the list. I've tried several things (obviously not the right
ones) but am stumped. I've included the CFQUERY code below...and some comments.
If anyone cna point me in the right direction, I would greatly appreciate it.

Thank you,
Craig

<cfquery name="getDetails">
SELECT clientid, projectid, project_name, project_description, start_date,
deadline, employeeid AS project_lead, lastUpdate, lastInvoice
FROM projects
<!--- I'm stuck here...trying to determine if the employee_list field contains
the passed in value, selector_id --->
WHERE employee_list CONTAINS #selector_id#
<!--- I know the above SQL is incorrect, I just thought this better
articulates what I want to do --->
</cfquery>

[Tulsa]

<cfquery name="getDetails">
SELECT clientid, projectid, project_name, project_description, start_date,
deadline, employeeid AS project_lead, lastUpdate, lastInvoice
FROM projects
</cfquery>

<cfoutput query = "getDetails">
<cfloop from="1" to="LISTLEN(#project_list#)" index="i">
<cfif LISTGETAT(project_list,index) is selector_id>
<!---Output project details here--->
</cfloop>
</cfoutput>