[thelist] CF / SQL problem

Try this on for size.  You can create the collection without going into the 
administrator....


<CFCOLLECTION ACTION="Create"
COLLECTION="#FORM.MyCollectionName#"
PATH="C:\CFUSION\Verity\Collections\">

Then write pull the information out that you want to search on....

<cfquery name="myquery" datasource="mydatasource">
select *
from mytable
where blah
</cfquery>

and stuff this info into your new collection....

<CFINDEX COLLECTION="collection_name"
     ACTION="action"
     TYPE="type"
     TITLE="title"
     KEY="ID"
     BODY="body"
     CUSTOM1="custom_value"
     CUSTOM2="custom_value"
     URLPATH="URL"
     EXTENSIONS="file_extensions"
     QUERY="query_name"
     RECURSE="Yes/No"
     EXTERNAL="Yes/No"
     LANGUAGE="language">

then create a form and search on it!..............

<CFSEARCH NAME="search_name"
COLLECTION="collection_name"
TYPE="criteria"
CRITERIA="search_expression"
MAXROWS="number"
STARTROW="row_number"
EXTERNAL="Yes/No"
LANGUAGE="language">

The CF Online Docs are really helpful - do you have access to those?  They 
do a god job explaining these different tags...

-w


At 08:31 AM 12/22/99 -0800, you wrote:


>The problem with using technical books as references and not actually reading
>them is you miss out on a lot of neat things.  The Verity search engine seems
>really cool and I'd never heard of it before.  Turns out there's an entire
>chapter on it  in my Ben Forta book.
>
>Sadly, I'm working on a corporate intranet and don't have access to the CF
>administrator in order to set up a verity collection.  So, that doesn't look
>like a viable option.
>
>Scott
>
>
>
>
>
>walker <walker@sdproductions.com> on 12/22/99 08:14:36 AM
>
>Please respond to thelist@lists.evolt.org
>
>To:   thelist@lists.evolt.org
>cc:    (bcc: Scott Brady/TMS)
>Subject:  Re: [thelist] CF / SQL problem
>
>
>You know, the verity search engine in CF works pretty well... have you
>tried it?
>
>instead of going through hell trying to create the right sql - you can
>create a collection and provide full text searching on it....
>
>I know its not the way you are going with this... but its an option.
>
>
>
>_______________________________________________________
>unsubscribe+options: http://lists.evolt.org/mailman/listinfo/thelist
>tip harvester: http://lists.evolt.org/harvest/
>email archive: http://lists.evolt.org/archive/
>http://evolt.org/  Workers of the Web, evolt !

____________________
walker fenton
http://www.sdproductions.com
303.898.7849