he means using the ColdFusion 5 + feature of using QueryOfQueries...
-----Original Message-----
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2003 16:22
To: CF-Talk
Subject: Re: Coldfusion and Verity Results ???
What do you mean by doing a query of queries ???
Has anybody on the list ever done anything like I am trying to achieve
before ?? there must be some example of how to achieve this search result
functionality with your verity search results???
If you look at what I have so far...................
<HTML>
<HEAD>
<TITLE>Search Results -</TITLE>
</head>
<body>
<cfif #Form.search# is "All"> <!--- radio button --->
<CFSET SearchCollection = "itlinks, downloads, itarticles">
<CFSET UseURLPath = "YES">
<cfelse>
<CFSET SearchCollection = "#Form.search#">
<CFSET UseURLPath = "YES">
</cfif>
<!--- retrieve requested files --->
<CFSEARCH
name = "GetResults"
collection = "#SearchCollection#"
criteria = "#Form.Criteria#"
maxRows = "#Evaluate(Form.MaxRows + 1)#"
startRow = "#Form.StartRow#"
>
<!--- search to calc no of records retreived--->
<CFSEARCH
name = "GetAllResults"
collection = "#SearchCollection#"
criteria = "#Form.Criteria#"
>
<!---Email search phrase entered by user under the following
conditions: --->
<!---i.e.: where "no files found" or where "startrow eq 1"--->
<!---Note: this will ensure that search phrase isn't emailed every time a
user moves on a page.--->
<cfif GetResults.RecordCount is 0 OR (Evaluate(Form.StartRow) eq 1)>
</cfif>
<!--- no files found for specified criteria? --->
<CFIF GetResults.RecordCount is 0>
<p><b>No files found for specified criteria</b></p>
<!--- ... else at least one file found --->
<CFELSE>
<cfif sgn(Evaluate(GetResults.RecordCount - Form.MaxRows)) -1>
<CFOUTPUT>
Your search for <b>"#Form.Criteria#"</b>found
<b>#GetAllResults.RecordCount#</b> matches.<br>
Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount
+ Form.StartRow -1)# of #GetAllResults.RecordCount# items
found.
</cfoutput>
<br>
<cfelse>
</cfif>
<p>
<CFOUTPUT>
Your search for <b>"#Form.Criteria#"</b>
found <b>#GetAllResults.RecordCount#</b> matche(s).<br>
Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount +
Form.StartRow -2)# of #GetAllResults.RecordCount# items found.
</cfoutput>
</cfif>
<cfif SearchCollection is "itlinks">
<CFOUTPUT query="GetResults" maxRows="#Form.MaxRows#">
<cfif lcase(custom2) eq lcase(session.division) OR lcase(custom2) eq
"all">
<B><a href="#custom1#">#title#</a></B>
<p>#summary#
<br>
Search Relevance :</span><span class="item2"> #NumberFormat
( Round ( Score * 100) )# %</p>
</cfif>
</CFOUTPUT>
<cfelseif SearchCollection is "downloads">
<cfoutput query="GetResults" maxRows="#Form.MaxRows#">
<cfif lcase(custom2) eq lcase(session.division) OR lcase(custom2) eq
"all">
<B><a
href="http://intranet.neath-porttalbot.gov.uk/itintranet/itdownloads/downloa
ds/#custom1#">#title#</a></B>
<p>#summary#<br>
Search Relevance :</span><span class="item2"> #NumberFormat
( Round ( Score * 100) )# %</p>
</cfif>
</CFOUTPUT>
<cfelseif SearchCollection is "itdocs">
<CFOUTPUT query="GetResults" maxRows="#Form.MaxRows#">
<B><a
href="http://intranet.neath-porttalbot.gov.uk/itintranet/itdocuments/documen
ts/#custom1#">#title#</a></B>
<p>#custom1#<br>
Search Relevance :</span><span class="item2"> #NumberFormat
( Round ( Score * 100) )# %</p>
</CFOUTPUT>
</cfif>
<cfelseif SearchCollection is "itarticles">
<CFOUTPUT query="GetResults" maxRows="#Form.MaxRows#">
<B><a
href="http://intranet.neath-porttalbot.gov.uk/itintranet/itnews/articledetai
l.cfm?id=#key#">#title#</a></B>
<p>#custom1#<br>
Search Relevance :</span><span class="item2"> #NumberFormat
( Round ( Score * 100) )# %</p>
</CFOUTPUT>
</cfif>
<cfelse>
<!---Start output for all results this is where I need some ideas on
getting searching all collections working--->
<!--- 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="http://intranet.neath-porttalbot.gov.uk/itintranet/home/searchresult
s.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="search" value="#Form.search#">
<input type="hidden" name="StartRow" value="#Evaluate(Form.StartRow +
Form.MaxRows)#">
<input type="submit" value=" More ... ">
</CFOUTPUT>
</form>
</CFIF>
</body>
</html>
----- Original Message -----
From: "Adam Reynolds" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 1:46 PM
Subject: RE: Coldfusion and Verity Results ???
> The verity results are in a query structure. You can always do a query of
> queries.
>
> > -----Original Message-----
> > From: A.Little [mailto:[EMAIL PROTECTED]]
> > Sent: 28 January 2003 12:32
> > To: CF-Talk
> > Subject: RE: Coldfusion and Verity Results ???
> >
> >
> > When you index each collection set custom2 to be some value, eg
> > 'link','download' etc. Then when you come to output the results just do
a
> > cfswitch/case to determine which link the key or title should go to and
> > display accordingly.
> >
> > Alex
> >
> > > -----Original Message-----
> > > From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> > > Sent: 28 January 2003 11:59
> > > To: CF-Talk
> > > Subject: Coldfusion and Verity Results ???
> > >
> > >
> > > Hi
> > >
> > > I would be grateful if somebody with an in depth experience
> > > of coldfusion
> > > and verity can help moe achive my goal here please....
> > >
> > > From the search form below the user has the option of
> > > searching all of the
> > > site or just individual collections such as Links, Software
> > > Downloads...
> > >
> > > <FORM action="search11.cfm" method="post" name="searchform">
> > >
> > > <input type="hidden" name="StartRow" value="1">
> > > <input type="hidden" name="MaxRows" value="25">
> > >
> > > Search for : <input name="Criteria" size="25" value="">
> > >
> > > <select name="search" size="1">
> > > <option value="All">All of the site</option>
> > > <option value="itlinks">Links</option>
> > > <option value="downloads">Software Downloads</option>
> > > <option value="itdocs">Document Knowledgebase</option>
> > > <option value="itarticles">News/Area</option>
> > > </select>
> > > </form>
> > >
> > > In the search results page how can the results of the search
> > > be shown, as
> > > the user may have chosen to search all the site (collections)
> > > if this is the
> > > case then I have the following problem...
> > >
> > > Because each link from each collection would be different for
> > > example (show
> > > below), how could this functionality be achieved in the results??
> > >
> > > <a href="/itdownloads/downloads/#custom1#">#title#</a>
> > > <a href="/itnews/articledetail.cfm?id=#key#">#title#</a>
> > > <a href="#custom1#">#title#</a>
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
