PDA

View Full Version : Help Me Coi dùm em cái code tìm kiếm này với !!!



teohaytam
07-03-2012, 11:10
<!--#include file="Connections/rs.asp" -->
<%
var rs1__MMColParam = "1";
if (String(Request.Form("timkiem")) != "undefined" &&
String(Request.Form("timkiem")) != "") {
rs1__MMColParam = String(Request.Form("timkiem"));
}
%>
<%
var rs1 = Server.CreateObject("ADODB.Recordset");
rs1.ActiveConnection = MM_rs_STRING;
rs1.Source = "SELECT TenSach, Gia FROM dbo.Sach WHERE TenSach = '"+ rs1__MMColParam.replace(/'/g, "''") + "' ORDER BY Gia DESC";
rs1.CursorType = 0;
rs1.CursorLocation = 2;
rs1.LockType = 1;
rs1.Open();
var rs1_numRows = 0;
%>
//hienj ra...
<%
var str=" ";
if(!rs1.EOF)
{
str = str + " " + rs1("TenSach") + "&nbsp;&nbsp;&nbsp;" + "|" + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + rs1("Gia") + " " + "<br>";
rs1.movenext;
}
Response.Write(str);
else
Response.write("không tìm Thấy Kết quả nào");
%>