ASP查询反馈页面,高手帮调试下,没搞定
来源:百度知道 编辑:UC知道 时间:2024/05/26 08:12:23
<%
set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("test.mdb")
SQL = "Select * From wardata Order By money DESC"
SET CustomerList = coon.EXECUTE(SQL)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>全部信息查询</title>
</head>
<body>
<table width="200" border="1">
<tr>
<td rowspan="2">编号</td>
<td rowspan="2">姓名</td>
<td rowspan="2">部门</td>
<td rowspan="2">工资</td>
</tr>
<% DO WHILE NOT CustomerList.EOF %>
<tr>
<td><% =CustomerList("
set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("test.mdb")
SQL = "Select * From wardata Order By money DESC"
SET CustomerList = coon.EXECUTE(SQL)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>全部信息查询</title>
</head>
<body>
<table width="200" border="1">
<tr>
<td rowspan="2">编号</td>
<td rowspan="2">姓名</td>
<td rowspan="2">部门</td>
<td rowspan="2">工资</td>
</tr>
<% DO WHILE NOT CustomerList.EOF %>
<tr>
<td><% =CustomerList("
SET CustomerList = coon.EXECUTE(SQL)
这一句马虎了,应该是Conn.execute(SQL)
如果有其它错误把错误信息也发上来吧。不知道数据库方面是否有错。