Ask a Question related to Coldfusion Database Access, Design and Development.
-
AAOS #1
verity and database collection
I am trying to create a Verity collection from a database table using a query.
It appears the collection is created but the search never finds any data. Dpes
anyone have any experience with this use of Verity? Thanks, Pam Attach Code
Code to create the collection <CFQUERY NAME='AllThreads'
DATASOURCE='Consumers'> select * from fact_master WHERE
fact_master.publish='Yes' </cfquery> <cfindex query='AllThreads'
collection='YOCcoll' action='Refresh' type='Custom' key='Thread_ID'
title='Thread_ID' body='Thread_ID,consumer_type,topcategory,Name,int ro'>
<cfoutput query='AllThreads'> #Thread_ID# #consumer_type# #topcategory# #Name#
#intro# </cfoutput> Code to enter search criteria <FORM
action='yoc_result.cfm' method='post'> <INPUT type='hidden' name='StartRow'
value='1'> <TABLE> <TR> <TD>Keywords:</TD> <TD><INPUT type='text'
name='Criteria' size='30'></TD> </TR> <TR> <TD>Max Rows:</TD>
<TD><SELECT name='MaxRows'> <OPTION> 10 <OPTION> 25 <OPTION> 100
</SELECT></TD> </TR> <TR> <TD colspan=2><INPUT type='submit' value='
Search '></TD> </TR> </TABLE> </FORM> Code to display results <!---
template settings ---> <CFSET SearchDirectory = '\\NT14\consumer'> <CFSET
SearchCollection = 'YOCcoll'> <CFSET UseURLPath = 'YES'> <!--- retrieve
requested files ---> <CFSEARCH name = 'GetResults' collection =
'#SearchCollection#' criteria = '#Form.Criteria#' maxRows =
'#Evaluate(Form.MaxRows + 1)#' startRow = '#Form.StartRow#' > <HTML><HEAD>
<TITLE>Your Orthopaedic Connection - Search Results</TITLE> </HEAD><BODY
bgcolor='#FFFFFF'> <FONT size='+1'>Your Orthopaedic Connection</FONT> <BR>
<FONT size='+2'><B>Search Results</B></FONT> <P> <!--- no files found for
specified criteria? ---> <CFIF GetResults.RecordCount is 0> <B>No files found
for specified criteria</B> <!--- ... else at least one file found --->
<CFELSE> <TABLE cellspacing=0 cellpadding=2> <!--- table header ---> <TR
bgcolor='cccccc'> <TD><B>No</B></TD> <TD><B>Score</B></TD>
<TD><B>File</B></TD> <TD><B>Title</B></TD> </TR> <CFOUTPUT
query='GetResults' maxRows='#Form.MaxRows#'> <TR bgcolor='#IIf(CurrentRow Mod
2, DE('FFFFFF'), DE('FFFFCF'))#'> <!--- current row information --->
<TD>#Evaluate(Form.StartRow + CurrentRow - 1)#</TD> <!--- score --->
<TD>#Score#&nbsp;</TD> <!--- file name with the link returning the
file ---> <TD> <CFIF UseURLPath> <!--- URL parameter from cfsearch
contains URL path info ---> <CFSET href = Replace(URL, ' ', '%20', 'ALL')>
<CFELSE> <!--- ... else use OpenFile to return the file ---> <CFSET
href = 'MyApplication_VOpenFile.cfm?serverFilePath=#URLEn codedFormat(Key)#'>
</CFIF> <A href='#href#'>#GetFileFromPath(Key)#</A> </TD> <!---
title for HTML files ---> <TD>#Title#&nbsp;</TD> </TR> </CFOUTPUT>
</TABLE> <!--- CFSEARCH tried to retrieve one more file than the number
specified in the Form.MaxRows parameter. If number of retrieved files is
greater than MaxRows we know that there is at least one file left. The
following form contains only one button which reloads this template with the
new StartRow parameter. ---> <CFIF GetResults.RecordCount gt Form.MaxRows>
<FORM action='yoc_result.cfm' method='post'> <CFOUTPUT> <INPUT
type='hidden' name='Criteria' value='#Replace(Form.Criteria, '''', ''',
'ALL')#'> <INPUT type='hidden' name='MaxRows' value='#Form.MaxRows#'>
<INPUT type='hidden' name='StartRow' value='#Evaluate(Form.StartRow +
Form.MaxRows)#'> <INPUT type='submit' value=' More ... '> </CFOUTPUT>
</FORM> </CFIF> </CFIF> </BODY></HTML> A wizard was used to create the
search and results pages
AAOS Guest
-
Verity not updating collection
This is a weird one. Using the Administrator, I have set up a few collections for our search engine to use. I have had no trouble indexing or... -
Verity collection on different server?
I am trying to setup a verity collection on a shared drive, i.e. not on the server where cfadministrator is but I don't know how to get cf... -
Verity collection issues
I've been using a system for searching in my CF powered apps for some years now, and it works pretty well., but now I've got a bit of a problem with... -
Can't create Verity Collection
When I try and create a verity collection in the CFAdmin or use cfcollection i get the following error Unable to create collection WebPageContent.... -
list a verity collection
Hi there, I was wondering if there was any way to create a query or list of a verity collection such that I can see an alphabetized word list of... -
AAOS #2 verity and database collection
I am trying to create a Verity collection from a database table using a query.
It appears the collection is created but the search never finds any data. Dpes
anyone have any experience with this use of Verity? Thanks, Pam Attach Code
Code to create the collection <CFQUERY NAME='AllThreads'
DATASOURCE='Consumers'> select * from fact_master WHERE
fact_master.publish='Yes' </cfquery> <cfindex query='AllThreads'
collection='YOCcoll' action='Refresh' type='Custom' key='Thread_ID'
title='Thread_ID' body='Thread_ID,consumer_type,topcategory,Name,int ro'>
<cfoutput query='AllThreads'> #Thread_ID# #consumer_type# #topcategory# #Name#
#intro# </cfoutput> Code to enter search criteria <FORM
action='yoc_result.cfm' method='post'> <INPUT type='hidden' name='StartRow'
value='1'> <TABLE> <TR> <TD>Keywords:</TD> <TD><INPUT type='text'
name='Criteria' size='30'></TD> </TR> <TR> <TD>Max Rows:</TD>
<TD><SELECT name='MaxRows'> <OPTION> 10 <OPTION> 25 <OPTION> 100
</SELECT></TD> </TR> <TR> <TD colspan=2><INPUT type='submit' value='
Search '></TD> </TR> </TABLE> </FORM> Code to display results <!---
template settings ---> <CFSET SearchDirectory = '\\NT14\consumer'> <CFSET
SearchCollection = 'YOCcoll'> <CFSET UseURLPath = 'YES'> <!--- retrieve
requested files ---> <CFSEARCH name = 'GetResults' collection =
'#SearchCollection#' criteria = '#Form.Criteria#' maxRows =
'#Evaluate(Form.MaxRows + 1)#' startRow = '#Form.StartRow#' > <HTML><HEAD>
<TITLE>Your Orthopaedic Connection - Search Results</TITLE> </HEAD><BODY
bgcolor='#FFFFFF'> <FONT size='+1'>Your Orthopaedic Connection</FONT> <BR>
<FONT size='+2'><B>Search Results</B></FONT> <P> <!--- no files found for
specified criteria? ---> <CFIF GetResults.RecordCount is 0> <B>No files found
for specified criteria</B> <!--- ... else at least one file found --->
<CFELSE> <TABLE cellspacing=0 cellpadding=2> <!--- table header ---> <TR
bgcolor='cccccc'> <TD><B>No</B></TD> <TD><B>Score</B></TD>
<TD><B>File</B></TD> <TD><B>Title</B></TD> </TR> <CFOUTPUT
query='GetResults' maxRows='#Form.MaxRows#'> <TR bgcolor='#IIf(CurrentRow Mod
2, DE('FFFFFF'), DE('FFFFCF'))#'> <!--- current row information --->
<TD>#Evaluate(Form.StartRow + CurrentRow - 1)#</TD> <!--- score --->
<TD>#Score#&nbsp;</TD> <!--- file name with the link returning the
file ---> <TD> <CFIF UseURLPath> <!--- URL parameter from cfsearch
contains URL path info ---> <CFSET href = Replace(URL, ' ', '%20', 'ALL')>
<CFELSE> <!--- ... else use OpenFile to return the file ---> <CFSET
href = 'MyApplication_VOpenFile.cfm?serverFilePath=#URLEn codedFormat(Key)#'>
</CFIF> <A href='#href#'>#GetFileFromPath(Key)#</A> </TD> <!---
title for HTML files ---> <TD>#Title#&nbsp;</TD> </TR> </CFOUTPUT>
</TABLE> <!--- CFSEARCH tried to retrieve one more file than the number
specified in the Form.MaxRows parameter. If number of retrieved files is
greater than MaxRows we know that there is at least one file left. The
following form contains only one button which reloads this template with the
new StartRow parameter. ---> <CFIF GetResults.RecordCount gt Form.MaxRows>
<FORM action='yoc_result.cfm' method='post'> <CFOUTPUT> <INPUT
type='hidden' name='Criteria' value='#Replace(Form.Criteria, '''', ''',
'ALL')#'> <INPUT type='hidden' name='MaxRows' value='#Form.MaxRows#'>
<INPUT type='hidden' name='StartRow' value='#Evaluate(Form.StartRow +
Form.MaxRows)#'> <INPUT type='submit' value=' More ... '> </CFOUTPUT>
</FORM> </CFIF> </CFIF> </BODY></HTML> A wizard was used to create the
search and results pages
AAOS Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
