I am trying to populate a collection with
Entry_ID and Entry_Text
Entry_ID is a number data type
and
Entry_Text is a Long data type.
I am using oracle and cf 4.5, I am not able to populate the index can
anyone tell me why? I use the cfindex properly and cfsearch properly,
however when I perform the search the recordssearched variable is not
defined, as if it weren't populated.
Below are my code blocks:
idx_NotebookEntries.cfm
******************************************************************
<cfquery datasource="notebooks" name="idx_Entries">
select Entries.ENTRY_ID,
Entries.ENTRY_TEXT
FROM Entries
</cfquery>
<CFINDEX COLLECTION="NotebookTest"
ACTION="Refresh"
TYPE="Custom"
TITLE= "Entry_ID"
KEY="ENTRY_ID"
BODY="ENTRY_TEXT"
QUERY="idx_Entries">
*******************************************************************
act_SearchResults.cfm
**********************************************************************
<CFSEARCH NAME="srch_EntryResults"
COLLECTION="NotebookTest"
CRITERIA="#form.Criteria#">
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists