On the same topic...(Quite urgent)

[rmz8]

How do I create a Verity collection so I can search a database of several fields. I have Administrator access, but I don't know how to make a collection with the database documents or implement it once it is created

 

[celley]

1.) go to the verity section of CF Admin
2.) add a collection. Just give it a name.
3.) on the next page, click on the index button.
4.) select the types of files you want to be indexed.
5.) choose the directory your files are in.
6.) click on the update button... and now you have a very collection that is ready to be used.

 

[rmz8]

I am familiar with setting up a Verity to search files. However, I want this to search database entries. Also, how do you implement the search function once the Verity collection is made?

 

[celley]

for database search....

<input type=&quot;test&quot; name=&quot;SearchString&quot;>

<input type=&quot;submit&quot; value=&quot;search&quot;>


----------------

<cfoutput>
<cfquery name=&quot;SearchDatabase&quot; datasource=&quot;#db#&quot;>
Select *
From YourTable
Where Field like '%#form.SearchString%#'
</cfquery>
</cfoutput>

 

[rmz8]

I want to do full-text searching. Not SQL searching. It is not powerful and inefficient. There is a way to create a custom Verity search function in order to search defined database fields. That is what I'm trying to do.