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
