When we're querying a database, we will usually need to press a submit button on a form to pass data to another ASP page, which would generate the query, and return the results. In some situations, this page refresh is just plain annoying and takes too long to complete. In this article, Phanix will describe another way to query a database using a combination of web technologies.
Our example is fairly simple, and we won’t be concentrating on actually adding the book to the database, rather the code to get a list of authors based on a keyword.
To actually execute the SQL query and return the results to the “MainFrame” frame, we need to create the processframe.asp page, so let’s do that now.