verity collection and database search problem

forums_noreply@adobe.com — Mon, 12 May 2014 16:31:51 GMT

Good morning, got a coldfusion question. I am currently working with coldfusion to create a search engine for a bunch of newspaper PDFs we have. I am having problem getting the Verity Collection and database to search as one. Any suggestions on how to get them both to search as one? Quick side note I have a search form and I have two results form. One results form is for the database and the other results form is for the Verity Collection. I have the search form linked to Both results form. I want to combine both results forms into one results. below is the one results I tried to combine but got an error.

SELECT digitalnewspaper.county, digitalnewspaper.doi, digitalnewspaper.town,

Newpapers.criteria, Newpapers.Summary, Newpapers.title, Newpapers.Context, digitalnewspaper.newspapername, digitalnewspaper.DOI, digitalnewspaper.town, digitalnewspaper.county

FROM Digitalnewspaper, Newpapers</cfquery>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><CFQUERY DATASOURCE="digitalnewspaper" name="digitalnewspaper">

SELECT *

FROM digitalnewspaper

WHERE 0=0

and NEWSPAPERNAME LIKE '#FORM.NEWSPAPERNAME#%'

</cfif>

AND DOI LIKE '%#FORM.DOI#%'

</cfif>

AND town LIKE '%#FORM.town#%'

</cfif>

AND county LIKE '%#FORM.county#%'

</cfif>

ORDER BY newspapername

</cfquery>

<CFOUTPUT>#NEWSPAPERNAME#<br>

#DOI#<br>

#TOWN#<br>

#COUNTY#<br>

#CRITERIA#

</CFOUTPUT>

<cfsearch Name= "Newpapers_Results"

collection= "newpapers"

type="simple"

criteria= #FORM.CRITERIA#

Status= "info"

Suggestions="5"

ContextHighlightBegin="<b>"

ContextHighlightEnd="</b>"

ContextPassages="1"

ContextBytes="500"

maxrows= "500">

<p>

<b>Document Title (if any): #Title#</b><br>

<b>Higlighted Summary:</b> #context# </p>

</cfoutput></td></tr></table></div>

</div>

<body>

</div>

<h2 align="center" class="style23">Digital Newspaper Database</h2>

<p class="style9">Your search returned #digitalnewspaper.RecordCount# records:</p>

</cfoutput>

<br>

</div>

<tr>

<th class="style9">PAPERID</th>

<th class="style9">STATE</th>

<th class="style9">County</th>

<th class="style9">NewspaperInfo</th>

<th class="style9">Other Info</th>

</tr>

<tr>

<div align="left"><span class="style9">#Newspapername#</span> </div></td>

<span class="style9">#PAPERID#</span> </td>

#STATE# </td>

<span class="style9">#county#</span> </td>

<td width="10%"><span class="style9">#Newspaperinfo#</span> </td>

#otherinfo# </td>

</tr>

</cfoutput>

</table>

</center>

div id="context">

</div>

<div align="left"><h2 class="style80">Search Results</h2></div>

Your search returned #newpapers_results.RecordCount# file(s).</span></cfoutput>

Did you mean:

<a href="search,cfm?query=#info.SuggestedQuery#>info.SuggestedQuery#</a>

</cfif>

<p align="center" class="style9">http://www.archives.alabama.gov/goldstar/results.cfm</p>

<p align="center" class="style9">Updated: February 6, 2014</p>

</center>

</td>

</tr></table>

</center>

<p><a href="http://www.archives.alabama.gov/FY09%20Strategic%20Plan%20080902%20(2).pdf" class="style2">"We tell the story of the people of Alabama by preserving records and artifacts of <br />

historical value and promoting a better understanding of Alabama history."</a></p>

<p align="center"><span class="style9"><a href="mailto:mark.palmer@archives.alabama.gov" class="style21">Contact Us</a> | <a href="/disclaimer.html" class="style21">Feedback</a> | <a href="http://www.archives.alabama.gov/adahindx.html" class="style21">Site Index</a></span><span class="style18"> | <span class="style9">Translate</span> | </span><span class="style9"><a href="http://www.alabama.gov/portal/index.jsp" class="style21">Alabama.gov</a></span></p>

</div>

<p align="center" class="style2">P.O. Box 300100 / 624 Washington Ave.</p>

<p align="center" class="style2">Montgomery, AL 36130</p>

</div>

</body>

</html>

Solr Collection PDF display problem

forums_noreply@adobe.com — Thu, 27 Mar 2014 20:30:32 GMT

I am having problems getting the Search collection I created to display the PDF files. When I perform a search I am able to get the pdf file listing put when I select a PDF file to display it it does nothing. Please help, below is the Search Action page I did

<head>

<title>Search Results</title>

</head>

<body>

<cfsearch

name= "newspaperarchive_results"

collection= "newspaperarchive"

criteria= "#Form.Criteria#">

ContextHighlightBegin="<b>"

ContextHighlightEnd="</b>"

ContextPassages="1"

ContextBytes="500"

maxrows= "100">

<h2>Search Results</h2>

Your search returned #newspaperarchive_results.RecordCount# file(s).

</cfoutput>

<p>

File: <a href="#url#">#key#</a><br>

Document Title (if any): #Title#<br>

Summary: #Summary#<b>

Highlighted Summary: #context#</p>

</cfoutput>

</body>

</html>

Searching pdf's

forums_noreply@adobe.com — Tue, 04 Mar 2014 14:55:55 GMT

Can you search pdf's using coldfusion 10

fails to link one collection

forums_noreply@adobe.com — Tue, 04 Mar 2014 14:49:18 GMT

how to get <cfsearch> to search one collection in CF 10

Coldfusion Collection linking problem

forums_noreply@adobe.com — Tue, 04 Mar 2014 14:40:32 GMT

I am in the process of creating a search engine in coldfusion. I can't get the search engine to pull the pdf files when trying to do a search. I created a collection in cold fusion administrator.

Adobe Community : All Content - All Communities

verity collection and database search problem

Solr Collection PDF display problem

Searching pdf's

fails to link one collection

Coldfusion Collection linking problem