whats the solution if you are using 4.5 ????
----- Original Message ----- From: "<"Robertson-Ravo>,Neil (RX)"" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 4:20 PM Subject: RE: Coldfusion and Verity Results ??? > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
