I have tried using criteria, #criteria#, form.criteria, #form.criteria#...I
don't think the problem is in the cfsearch, my index is not being populated
at all, because when I use cf_showquery on the search result it shows no
recordssearched. I have attached my code, can anyone tell me why my verity
collection is not getting populated?!? I am stumped!
<cfquery datasource="notebooks" name="idx_Entries">
select notebook_ID,
notebook_title
FROM Notebooks
</cfquery>
<CFINDEX COLLECTION="Notebook"
ACTION="Refresh"
TYPE="Custom"
TITLE= "Notebook_ID"
KEY="Notebook_ID"
BODY="Notebook_title"
QUERY="idx_Entries">
At 12:34 PM 9/12/2001 -0400, you wrote:
> > I am having a very difficult time with populating a verity
> > index. I have defined the collection with cfserver. I am using
> > a query to populate it. here is my code blocks, can anyone please
> > tell me what I am doing wrong here?
> >
> > ...
> >
> > The cf_showquery will show everything I have selected but nothing
> > is searched in the cfsearch tag...here is my code for that:
> >
> > <CFSEARCH NAME="srch_EntryResults"
> > COLLECTION="NotebookTest"
> > CRITERIA="Criteria">
> > <cfoutput>Note entries containing #form.criteria#:<br></cfoutput>
> > <cf_showquery query="srch_EntryResults">
> >
> >
> > This showquery shows no results. Even the recordssearched is
> > not defined, as if nothing was searched at all.
>
>My guess is that you're passing the literal string "Criteria" to CFSEARCH;
>instead, you should be evaluating that variable within the literal string
>argument:
>
><cfsearch name="srch"
> collection="mycollection"
> criteria="#Form.Criteria#">
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
