高手帮忙看下我的代码.传值问题!
来源:百度知道 编辑:UC知道 时间:2024/07/01 06:24:17
<!--#include file="conn.asp" -->
<%
dim id2,id,rs,rs2,sql,sql2
set rs=server.createobject("adodb.recordset")
sql="select customer.customerid,customer.customername from customer"
rs.open sql,conn,3,2
conn.execute(sql)
id2=request.QueryString("id2")
sql2="select bookingdate from booking where customerid=" & id2
set rs2=server.createobject("adodb.recordset")
rs2.open sql2,conn,1,1
conn.execute(sql2)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<p align="left"> Customer</p>
<table width="383" height="58" border="1">
<tr>
&
<%
dim id2,id,rs,rs2,sql,sql2
set rs=server.createobject("adodb.recordset")
sql="select customer.customerid,customer.customername from customer"
rs.open sql,conn,3,2
conn.execute(sql)
id2=request.QueryString("id2")
sql2="select bookingdate from booking where customerid=" & id2
set rs2=server.createobject("adodb.recordset")
rs2.open sql2,conn,1,1
conn.execute(sql2)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<p align="left"> Customer</p>
<table width="383" height="58" border="1">
<tr>
&
提示错误是什么
另外
rs.open sql,conn,3,2
conn.execute(sql)
rs2.open sql2,conn,1,1
conn.execute(sql2)
这两个地方,你都用rs打开后又调用了conn.execute方法,实在不知道你多些那一行干什么...