Ray Thanks for your help the following q of q solved the problem
<cfquery name="GetResults" dbtype="query"> select * from GetResults where custom2 IN (#PreserveSingleQuotes(session.groupname)#) </cfquery> -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 18:02 To: CF-Talk Subject: Re: Verity and Security Not handy - but check the docs. Basically - assuming "data" is your info from cfsearch, you can do (pseudo-code) <cfquery name="filteredData" dbtype="query"> select * from data where cf_custom2 = put your session var here </cfquery> On 5/23/05, Ian Vaughan <[EMAIL PROTECTED]> wrote: > Seems very strange how it does not work ? > > Do you have an example of a query of query I could use to test please, > > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: 23 May 2005 14:32 > To: CF-Talk > Subject: Re: Verity and Security > > Sorry then - I'm at a lost. As I mentioned, when I tried a local > version, it worked just fine. You could consider using query of query > to filter the results. > > On 5/23/05, Ian Vaughan <[EMAIL PROTECTED]> wrote: > > Yes, tried CONTAINS as well, same result - no records found ? > > > > -----Original Message----- > > From: Raymond Camden [mailto:[EMAIL PROTECTED] > > Sent: 20 May 2005 17:10 > > To: CF-Talk > > Subject: Re: Verity and Security > > > > Did you try <CONTAINS> as well? > > > > On 5/20/05, Ian Vaughan <[EMAIL PROTECTED]> wrote: > > > Nope even with the quotes shown in the results page I sent in the > > > last > > > > > post, the search is returning no results ? . > > > > > > What is strange though is if I remove the > > > > > > and CF_CUSTOM2 <IN> ""#session.groupname#""" > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
