RE: Verity and Security

2005-05-24 Thread Ian Vaughan
: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

RE: Verity and Security

2005-05-24 Thread James Holmes
PROTECTED] Sent: Tuesday, 24 May 2005 4:49 To: CF-Talk Subject: RE: Verity and Security 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

RE: Verity and Security

2005-05-23 Thread Ian Vaughan
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

Re: Verity and Security

2005-05-23 Thread Raymond Camden
- 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

RE: Verity and Security

2005-05-23 Thread Ian Vaughan
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

Re: Verity and Security

2005-05-23 Thread Raymond Camden
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

RE: Verity and Security

2005-05-20 Thread Ian Vaughan
=submit value=More Results ... /CFOUTPUT /form /CFIF /CFIF -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 19 May 2005 19:14 To: CF-Talk Subject: Re: Verity and Security Are you inside a cfloop query

Re: Verity and Security

2005-05-20 Thread Raymond Camden
I'm confused. I thought you said the search was working now - since you added quotes around the part for custom2. I thought it was working but you just had a bug with the cfdump? On 5/20/05, Ian Vaughan [EMAIL PROTECTED] wrote: Ray In my search I was just doing a cfdump var=#custom2#.

RE: Verity and Security

2005-05-20 Thread Ian Vaughan
is populated. It seems strange then that when the following code above is added no results come back ?? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 20 May 2005 12:25 To: CF-Talk Subject: Re: Verity and Security I'm confused. I thought you said the search

Re: Verity and Security

2005-05-20 Thread Raymond Camden
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#

Re: Verity and Security

2005-05-20 Thread Jerry Johnson
You might try CONTAINS on a field you know is standard and populated and where you know what the data looks like (to get the syntax down) like TITLE On 5/20/05, Raymond Camden [EMAIL PROTECTED] wrote: Did you try CONTAINS as well?

RE: Verity and Security

2005-05-19 Thread Ian Vaughan
+ 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

RE: Verity and Security

2005-05-19 Thread Ian Vaughan
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 +

Re: Verity and Security

2005-05-19 Thread 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

RE: Verity and Security

2005-05-19 Thread Ian Vaughan
] Sent: 19 May 2005 14:16 To: CF-Talk Subject: Re: Verity and Security 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

Re: Verity and Security

2005-05-19 Thread Jerry Johnson
I haven't been following this thread, so I may be repeating something already said, but... Don't you need to put the groupname in double quotes (make it a phrase) if it contains spaces or reserved words for verity queries? so... CONTAINS #session.groupname# Jerry Johnson Web Developer On

Re: Verity and Security

2005-05-19 Thread Raymond Camden
IT' -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 19 May 2005 14:16 To: CF-Talk Subject: Re: Verity and Security So when you remove the second portion - and you cfdump the results, you do see custom2 containing #session.groupname#, correct? On 5/19/05

RE: Verity and Security

2005-05-19 Thread Ian Vaughan
Ray Yeah when removing the second portion ( and CF_CUSTOM2 CONTAINS #session.groupname# ) and cfdump the results cfdump var=#getresults# I am seeing custom 2 with the correct groupname for that document i.e. 'ALL IT' ~|

RE: Verity and Security

2005-05-19 Thread Ian Vaughan
May 2005 15:10 To: CF-Talk Subject: Re: Verity and Security I haven't been following this thread, so I may be repeating something already said, but... Don't you need to put the groupname in double quotes (make it a phrase) if it contains spaces or reserved words for verity queries? so

Re: Verity and Security

2005-05-19 Thread Raymond Camden
Remember to escape quotes. You would need to change #session.groupname# to #session.groupname#. I'm not convinced htat is your problem - but try it. On 5/19/05, Ian Vaughan [EMAIL PROTECTED] wrote: Jerry Thanks for the tip, just tried what you suggested CFSEARCH name = GetResults

Re: Verity and Security

2005-05-19 Thread Jerry Johnson
Remember to escape the double quotes (put two doublequotes together) within a doulequoted string ... #HTMLEditFormat(Form.Criteria)# and CF_CUSTOM2 CONTAINS #session.groupname# Jerry Johnson Web Developer On 5/19/05, Ian Vaughan [EMAIL PROTECTED] wrote: Jerry Thanks for the tip, just tried

RE: Verity and Security

2005-05-19 Thread Ian Vaughan
is populated? -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 19 May 2005 16:42 To: CF-Talk Subject: Re: Verity and Security Remember to escape the double quotes (put two doublequotes together) within a doulequoted string ... #HTMLEditFormat(Form.Criteria

Re: Verity and Security

2005-05-19 Thread Jerry Johnson
Listen to Ray more than me, because I half (thankfully) flushed all Verity knowledge from my brain 6 months ago. Now it is full of FTS search knowledge. I also never used the custom fields, but instead customized the .zon and .ddd files. When I searched, I always wrote my verity queries like:

Re: Verity and Security

2005-05-19 Thread Raymond Camden
Are you inside a cfloop query=your search result, or cfoutput query=yoursearchresult? custom2 is one of the columns returned in the query result. On 5/19/05, Ian Vaughan [EMAIL PROTECTED] wrote: Ray / Jerry That seems to have solved that problem, but it is stating that the custom2 variable

RE: Verity and Security

2005-05-18 Thread Ian Vaughan
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 lt;CONTAINSgt; As a side note, maxRows = #Evaluate

Re: Verity and Security

2005-05-18 Thread Raymond Camden
(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

Re: Verity and Security

2005-05-17 Thread Deanna Schneider
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. - Original Message - From: Ian Vaughan [EMAIL

RE: Verity and Security

2005-05-17 Thread Ian Vaughan
BY dldate DESC /cfquery -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: 17 May 2005 14: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

RE: Verity and Security

2005-05-17 Thread James Holmes
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

RE: Verity and Security

2005-05-17 Thread Ian Vaughan
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

Re: Verity and Security

2005-05-17 Thread Raymond Camden
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

RE: Verity and security through obscurity

2005-02-01 Thread Dave Watts
I wanted to get some feedback on how you go about scheduling the re-indexing of files with Verity, and where the actual code runs. Do you usually put your re-indexing code in a web-accessible directory and just use the cfschedule tag or admin to run it? Do you use a scheduled task with

RE: Verity and security through obscurity

2005-02-01 Thread Burns, John D
You could put it in a directory on your webserver that has access limited to 127.0.0.1 which would only allow the page to be called from on the server itself. This should allow CF to call it or if you were physically on the machine you could call it, but no one could call it directly from another

RE: Verity and security through obscurity

2005-02-01 Thread Jim Davis
-Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 2:47 PM To: CF-Talk Subject: Verity and security through obscurity Hi everyone, Obscuring the file doesn't seem to be the best solution, but if you're using cfschedule, I don't

RE: Verity and Security.. ??

2001-03-05 Thread Philip Arnold - ASP
ColdFusion is set up to handle security, which means that user's sign in via a web form. A userID is cross-referenced with the table data and before showing any 'secure' data, the system checks to make sure the current user has access to it. If I create a verity collection with all

RE: Verity and Security.. ??

2001-03-05 Thread Jeffry Houser
Absolutely brilliant!! I wish I had thought of that, much thanks. At 04:29 PM 03/05/2001 +, you wrote: ColdFusion is set up to handle security, which means that user's sign in via a web form. A userID is cross-referenced with the table data and before showing any 'secure'

RE: Verity and Security.. ??

2001-03-05 Thread Belfiori, Ross
But, what if the secure data is not in a table, but documents. Don't the custom fields only work when indexing against a database? Ropo -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 2:07 PM To: CF-Talk Subject: RE: Verity and Security

RE: Verity and Security.. ??

2001-03-05 Thread James McCullough
the cfsearch output to check for this. -Original Message- From: Belfiori, Ross [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 11:38 AM To: CF-Talk Subject: RE: Verity and Security.. ?? But, what if the secure data is not in a table, but documents. Don't the custom fields only work