<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var Recordset1__authorR = "%"; if (String(Request.Form("author-field")) != "undefined" && String(Request.Form("author-field")) != "") { Recordset1__authorR = String(Request.Form("author-field")); } %> <% var Recordset1__titleR = "%"; if (String(Request.Form("title-field")) != "undefined" && String(Request.Form("title-field")) != "") { Recordset1__titleR = String(Request.Form("title-field")); } %> <% var Recordset1__topicR = "%"; if (String(Request.Form("topic-field")) != "undefined" && String(Request.Form("topic-field")) != "") { Recordset1__topicR = String(Request.Form("topic-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 Recordset1 = Server.CreateObject("ADODB.Recordset"); Recordset1.ActiveConnection = MM_QuintResults_STRING; // "SELECT * FROM Products WHERE Medium = '"+ Recordset1__typeR.replace(/'/g, "''") + "' AND Author LIKE '%' + '"+ Recordset1__authorR.replace(/'/g, "''") + "' + '%' "+ LiamsVar.replace(/'/g, "''") + " Product_Description LIKE '%' + '"+ Recordset1__titleR.replace(/'/g, "''") + "' + '%' "+ LiamsVar2.replace(/'/g, "''") + " ISBN = '"+ Recordset1__isbnR.replace(/'/g, "''") + "' AND Topic LIKE '"+ Recordset1__topicR.replace(/'/g, "''") + "'"; Recordset1.Source = "SELECT * FROM Products WHERE Author LIKE '%' + '"+ Recordset1__authorR.replace(/'/g, "''") + "' + '%' AND Product_Description LIKE '%' + '"+ Recordset1__titleR.replace(/'/g, "''") + "' + '%' AND Topic LIKE '"+ Recordset1__topicR.replace(/'/g, "''") + "'"; Recordset1.CursorType = 0; Recordset1.CursorLocation = 2; Recordset1.LockType = 1; Recordset1.Open(); var Recordset1_numRows = 0; %> <% var Repeat1__numRows = 10; var Repeat1__index = 0; Recordset1_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = 30; var Repeat1__index = 0; Recordset1_numRows += Repeat1__numRows; %> Dental books, books about dentistry, journals, videotapes, CD-ROMs, DVDs
Quintessence publishing
Quintessence Books
  Publishers of professional dental journals, books and multimedia

Catalogue | Price List | Ordering | New Titles | News | Contact | Home    

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