ahhh one more for the road.......
<!--- get the list.... --->
<cfquery name="query1" datasource="#request.data#">
select list
from table
</cfquery>
<!--- check an ID against that list through a query.... --->
<cfquery name="query2" datasource="#request.data#">
select ANYTHING TO GET A RECORDCOUNT
from table
where userID = #ID# AND
userid IN (#list#)
</cfquery>
<cfif query2.recordcount EQ 1>
SUCCESS!
<cfelse>
DENIED!
</cfif>
dead thread.......
----- Original Message -----
From: "Ewok" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 7:06 PM
Subject: Re: Query Issue
> Im probably way off what you mean
>
> select list
> from table
>
> <cfset success = Listfind(query.list, #ID#)>
>
> <cfif success>
> SUCCESS
> <cfelse>
> DENIED
> </cfif>
>
>
>
>
> ----- Original Message -----
> From: "Tony Gruen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, May 20, 2002 6:42 PM
> Subject: Query Issue
>
>
> > Howdy List!
> >
> > Can someone please 'gimmie a thread' on this? (ie: Brain thread, as in
cpu
> > thread)
> >
> > I have an existing database with a field named 'AccessList'. This field
is
> a
> > comma delimited list of IDs (numeric only). These IDs are for users who
> are
> > to be granted access to a function. For example one entry would be
> > 4,15,26,44,101,9.
> >
> > I am trying to devise a query that will check the field for a single
> userID.
> > Say 4 for example... note that 44 also exists in the list.
> >
> > My fumbling attempts to devise a way using LIKE and IN are not working.
> >
> >
> >
> >
> >
> >
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
