Looking for a way to take a numeric variable x and find it in a list within
a column.
A client logs in and has an authoritylevelid assigned to them. I need to
retrieve all documents where the authoritylevel is found in the
authoritylevelid list in the documents table.
Something like this.
<CFQUERY>
SELECT DOCUMENTNAME
FROM TBL_DOCUMENTS
WHERE #VARIABLES.X# IN (AUTHORITYLEVELID)
</CFQUERY>
I know this will not work above is there a way I can find x in the
authoritylevel list?
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
