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:207045 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
