Originally Posted by Retox Josh

SELECT title FROM table WHERE title LIKE '%$_GET['q']%'

ofcourse its dirty, you will want to do alot of shit to the $_GET to make sure its not a malicious get and other bullshit, but it'll help you

using php/mysql by the way

Originally Posted by Retox Josh

SELECT title FROM table WHERE title LIKE '%$_GET['q']%'

ofcourse its dirty, you will want to do alot of shit to the $_GET to make sure its not a malicious get and other bullshit, but it'll help you

using php/mysql by the way

Originally Posted by Verity Info

To efficiently search through paragraphs of text or files of varying types, you need full-text search capabilities. ColdFusion includes the Verity search engine, which provides full-text indexing and searching.

The Verity engine performs searches against collections, not against the actual documents. A collection is a special database created by Verity that contains metadata that describes the documents that you have indexed. The indexing process examines documents of various types in a collection and creates a metadata description--the index--which is specialized for rapid search and retrieval operations.

The ColdFusion implementation of Verity supports collections of the following basic data types:

* Text files such as HTML pages and CFML pages
* Binary documents (see Supported file types)
* Record sets returned from cfquery, cfldap, and cfpop queries

You can build collections from individual documents or from an entire directory tree. Collections can be stored anywhere, so you have much flexibility in accessing indexed data.

In your ColdFusion application, you can search multiple collections, each of which can focus on a specific group of documents or queries, according to subject, document type, location, or any other logical grouping. Because you can perform searches against multiple collections, you have substantial flexibility in designing your search interface.