<%@LANGUAGE="JAVASCRIPT"%> <% var isbnsearch__MMColParam = "1"; if (String(Request.Form("isbn-field")) != "undefined" && String(Request.Form("isbn-field")) != "") { isbnsearch__MMColParam = String(Request.Form("isbn-field")); } %> <% //if (String(Request.Form("isbn-field")) != "undefined" && String(Request.Form("isbn-field")) != "") // && String(Request.Form("isbn-field")) != "undefined" && String(Request.Form("isbn-field")) != "") //{ var LiamsVar2 = "AND" //} else //{ var LiamsVar2 = "OR" //} %> <% var isbnsearch = Server.CreateObject("ADODB.Recordset"); isbnsearch.ActiveConnection = MM_QuintResults_STRING; // "SELECT * FROM Products WHERE Medium = '"+ isbnsearch__typeR.replace(/'/g, "''") + "' AND Author LIKE '%' + '"+ isbnsearch__authorR.replace(/'/g, "''") + "' + '%' "+ LiamsVar.replace(/'/g, "''") + " Product_Description LIKE '%' + '"+ isbnsearch__titleR.replace(/'/g, "''") + "' + '%' "+ LiamsVar2.replace(/'/g, "''") + " ISBN = '"+ isbnsearch__isbnR.replace(/'/g, "''") + "' AND Topic LIKE '"+ isbnsearch__topicR.replace(/'/g, "''") + "'"; isbnsearch.Source = "SELECT * FROM Products WHERE ISBN = '"+ isbnsearch__MMColParam.replace(/'/g, "''") + "' ORDER BY Product_Description"; isbnsearch.CursorType = 0; isbnsearch.CursorLocation = 2; isbnsearch.LockType = 1; isbnsearch.Open(); var isbnsearch_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; isbnsearch_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = 30; var Repeat1__index = 0; isbnsearch_numRows += Repeat1__numRows; %> Untitled Document
  QUINTESSENCE BOOKS UK
  Publishers of professional dental journals, books and multimedia 		 

ISBN Book Search Results

<% while ((Repeat1__numRows-- != 0) && (!isbnsearch.EOF)) { %> <% Repeat1__index++; isbnsearch.MoveNext(); } %>
Author
Title
Price
Topic
  
<%=(isbnsearch.Fields.Item("Author").Value)%>
<%=(isbnsearch.Fields.Item("Product_Description").Value)%>
£<%=(isbnsearch.Fields.Item("Price").Value)%>
<%=(isbnsearch.Fields.Item("Topic").Value)%>
<% if (isbnsearch.EOF && isbnsearch.BOF) { %> Sorry no results found <% } // end isbnsearch.EOF && isbnsearch.BOF %>
<% isbnsearch.Close(); %>