1 Reply Latest reply on Oct 29, 2012 4:39 PM by Dan Bracuk

    search and display database records


      hello, kindly help me as to how to create a search page with multiple search parameters and how to display the result (within same page or on a different page). i am a dummy and i am using dot php/// pls very urgent. thanks

        • 1. Re: search and display database records
          Dan Bracuk Level 5

          easycfm.com has entry level tutorials.


          This book, http://forta.com/books/032166034X/, will help you get started.


          For your specific questions, you can have a simple html form for your search page. 


          Whether you process the form on the same page or a different one doesn't really matter, but on that page, the form fields you submitted will now be cf variables in the form scope.  You use the cfquery tag to send your sql to the db, and the cfoutput tag to display the results.


          google and coldfusion play well together.  If you search on cfquery, the adobe documentation will usually be the first offering.