So when you remove the second portion - and you cfdump the results, you do see custom2 containing #session.groupname#, correct?
On 5/19/05, Ian Vaughan <[EMAIL PROTECTED]> wrote: > Ray > > I changed what you suggested shown below, but it is still returning no > results ?? > > <CFSEARCH > name = "GetResults" > collection = "idocs" > type = "simple" > criteria = "#Form.Criteria# and CF_CUSTOM2 <CONTAINS> > #session.groupname#" > maxRows = "#Evaluate(Form.MaxRows + Form.StartRow)#" > startRow = "#Form.StartRow#" > > > > > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: 18 May 2005 16:56 > To: CF-Talk > Subject: Re: Verity and Security > > You need to change CUSTOM2 to CF_CUSTOM2 > > On 5/18/05, Ian Vaughan <[EMAIL PROTECTED]> wrote: > > I have tried what you suggested by removing the htmleditformat and the > > > preserve single quotes, but it is still returning no results?? When it > > > should be returning results? > > > > Can anybody see anything else which may be causing this problem? > > > > <CFSEARCH > > name = "GetResults" > > collection = "idocs" > > type = "simple" > > criteria = "#Form.Criteria# and CUSTOM2 <CONTAINS> > > #session.groupname#" > > maxRows = "#Evaluate(Form.MaxRows + Form.StartRow)#" > > startRow = "#Form.StartRow#" > > > > > > > If I run the original code below, it returns all matched results not > > just the results the users security is allowed to view > > > > <CFSEARCH > > name = "GetResults" > > collection = "idocs" > > type = "simple" > > criteria = "#HTMLEditFormat(Form.Criteria)#" > > maxRows = "#Evaluate(Form.MaxRows + Form.StartRow)#" > > startRow = "#Form.StartRow#" > > > > > > > -----Original Message----- > > From: Raymond Camden [mailto:[EMAIL PROTECTED] > > Sent: 17 May 2005 17:47 > > To: CF-Talk > > Subject: Re: Verity and Security > > > > You don't need the preservesinglequotes for sure. This isn't a SQL > call. > > > > Also, the HTMLEditFormat is wrong. It will break <CONTAINS> to be > > <CONTAINS> > > > > As a side note, > > maxRows = "#Evaluate(Form.MaxRows + Form.StartRow)#" > > > > should be > > > > maxRows="#form.maxrows+form.startrow#" > > > > On 5/17/05, Ian Vaughan <[EMAIL PROTECTED]> wrote: > > > James > > > > > > Just tried the following code below and added the (and CUSTOM2 > > > <CONTAINS> #PreserveSingleQuotes(session.groupname)#, however the > > > search returns no results ?? > > > > > > Can anybody see what could be causing this? > > > > > > <CFSEARCH > > > name = "GetResults" > > > collection = "idocs" > > > type = "simple" > > > criteria = "#HTMLEditFormat(Form.Criteria)# and CUSTOM2 <CONTAINS> > > > #PreserveSingleQuotes(session.groupname)#" > > > maxRows = "#Evaluate(Form.MaxRows + Form.StartRow)#" > > > startRow = "#Form.StartRow#" > > > > > > > > > > > > > -----Original Message----- > > > From: James Holmes [mailto:[EMAIL PROTECTED] > > > Sent: 17 May 2005 14:51 > > > To: CF-Talk > > > Subject: RE: Verity and Security > > > > > > There's a format to query the custom fields directly, using > > > <CONTAINS> > > > > > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/indexs22.htm > > > > > > -----Original Message----- > > > From: Deanna Schneider [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, 17 May 2005 9:44 > > > To: CF-Talk > > > Subject: Re: Verity and Security > > > > > > I think you'll have to with query of query - unless you can use > > > verity's language to filter - something like AND "Group A" - but if > > > you had a document that contained "Group A" but belonged to group b, > > > > you'd be screwed - so back to QofQ. > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207137 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
