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:206995 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54