Ok,
tbl_documents
DocumentName, varchar
AuthorityLevelID varchar (this contains data like 1,2,3)
I have a user with an authoritylevelid of 3 I need to pull a document which
has 3 within the authoritylevelid list.
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 4:07 PM
To: CF-Talk
Subject: RE: x in sql list column
doesn't sound too hard....
knowing the column/table layout would be a bit easier to help ya ;-)
.tony
Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 4:00 PM
To: CF-Talk
Subject: x in sql list column
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?
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
