留言版的问题-JavaScript不适合写ASP?
紫郢剑侠 2003-12-05 05:44:57 以下是显示留言版内容的程序, 当不传递typ、Page、obj等参数的值时出错:
Page=-1 typ=undefined obj=undefined
sql = Select * from leaword where undefined like '%%undefined%%';
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/disp_leaword.asp,行35
请大虾指点。这个程序是从VBS描述的ASP改写而来,难道JS不适合写ASP?
//以下是显示留言版内容的程序
<% @language="JavaScript" %>
<%
var Page, typ, obj;
if (Request.QueryString("typ")=="undefined")
{
Page = Request.QueryString("Page") - 1;
// typ = Request.QueryString("typ");
// obj = Request.QueryString("obj");
}
else
{
Page = -1;
typ = Request.Form("selSeach");
obj = Request.Form("txtSearch");
}
Response.Write("Page=" + Page + " typ=" + typ + " obj=" + obj + "<br>");
var sql;
if (Page!=-1)
{
sql = "Select * from leaword";
}
else
{
sql = "Select * from leaword where " + typ + " like '%%" + obj + "%%';";
}
Response.Write("sql = " + sql + "<br>");
var res = Server.CreateObject("ADODB.RecordSet");
var DBName = "driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("guest.mdb");
res.Open(sql, DBName, 1, 1);
//var conn = Server.CreateObject("ADODB.Connection");
//不能写成conn.Open("driver = {Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("guest.mdb"));
// ^ ^ 不能有空格
//conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("guest.mdb"));
//res.Open(sql, conn, 1, 1);
if (res.RecordCount==0) //不能写成res.RecordCount()
{
Response.Write("<p align='center'><font color=red size=6>No Found!</font></p>");
Response.Write("<p align='center'><a href='javascript:history.go(-1)'>Return</a></p>");
res.close();
}
else
{
Response.Write("<p>Search:");
Response.Write("<form method='POST' action='disp_leaword.asp'>共有" + res.RecordCount + "条记录!<br>");
Response.Write("<select NAME='selSearch' size='1'><option value='ID'>ID</option><option selected value='Caption'>Caption</option></select>");
Response.Write("<INPUT TYPE='text' NAME='txtSearch' size='20'><input type='submit'></form></p><br>你要查看第几页?");
for (var i = 1; i <= (res.RecordCount/20+1); i++)
{
Response.Write("<a href='disp_leaword.asp?Page=" + i + "&typ=" + typ + "&obj=" + obj + "'>第" + i + "页</a> ");
}
Response.Write("<p>");
for (var j = 0; j <= Page*20-1; j++)
{
res.MoveNext;
}
var count = 0;
while (count!=20 && !res.EOF)
{
var ID = res("ID");
var Caption = res("Caption");
var Leaword = res("Leaword");
Response.Write("<div style='width:100%;'><span style='width:100%;background: purple; color: yellow;width:30%'>[ID] " + ID + "</span><span style='background:yellow; color:purple; width:70%;'>[Caption] " + Caption + "</span></div>" + "<div style='border:1 solid purple; color:purple'>" +Leaword + "</div><P>");
//Response.Write("<hr noshade size=1 color=#009900>");
res.MoveNext;
count++;
}
res.Close();
conn.Close(); //conn=nothing;
}
Response.Write("<a href='leaword.htm'>我要留言</a> ");
for (j = 1; j < i; j++)
{
Response.Write("<a href='disp_leaword.asp?Page=" + j + "&typ=" + typ + "&obj=" + obj + "'>第" + j + "页</a> ");
}
%>