All, I created a collection, populated it with a query and then created a simple form to search against the collection and I get http 500? ... (see cf code below)
This is all on my localhost 127.0.0.1. CF Search Server service is running. The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following: Open the 127.0.0.1:8500 home page, and then look for links to the information you want. Click the Refresh button, or try again later. Click Search to look for information on the Internet. You can also see a list of related sites. HTTP 500 - Internal server error Internet Explorer <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Untitled Document</title> </head> <body> <!---EXAMPLE #3: Index a QUERY (type = "custom") ------------> <!--- Retrieve data from the table. ---> <cfquery name="getDept" datasource="bar"> SELECT * FROM tblArticle </cfquery> <!--- Update the collection with the above query results. ---> <!--- key is Article_ID in the Article table. ----> <!--- body specifies the columns to be indexed for searching. ---> <cfindex query="getDept" collection="msj_department" action="Update" type="Custom" key="Article_ID" title="Articles" body="Department" > <h2>Indexing Complete</h2> <CFIF isdefined ("searchgogo")> <cfsearch name = "MSJ_Search" collection = "msj_department" contextpassages = "1" maxrows = "100" CRITERIA="#FORM.SearchText#" > <cfoutput> Title=#MSJ_Search.Title#<br /> SubTitle=#MSJ_Search.Subtitle#<br /> Department=#MSJ_Search.Department#<br /> Author=#MSJ_Search.Author_1_fname# #MSJ_Search.Author_1_lname#<br /> </cfoutput> <CFELSE> <form action="create_indexs2.cfm" method="post"> <table width="341" height="132" border="0"> <tr> <td>Search:</td> <td> </td> </tr> <tr> <td><input type="text" name="SearchText"></td> <td> </td> </tr> <tr> <td> <input name="searchgogo" type="hidden" value="yes"> <input type="submit" name="Submit" value="search"></td> <td> </td> </tr> </table> </form> </CFIF> </body> </html> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247077 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
