UC知道谁会ASP帮忙看下代码，谢谢。
来源：百度知道 编辑：UC知道 时间：2024/05/14 05:05:19
<% dim con_book,rs_book,sql,camera_ID
camera_ID=request("camera_ID") '取得BookManager.asp传送的图书编号
Set con_Book=Server.CreateObject("ADODB.Connection")
con_Book.Open "DSN=DigitalCamerasSource;uid=sa;pwd=;"
Set rs_Book=Server.CreateObject("ADODB.Recordset")
rs_book.CursorType=adOpenStatic
sql="select * from camera_Info B,manufacturer P where(B.Press_ID=P.Press_ID)"
sql=sql&"and (camera_ID="&camera_ID&")"
rs_book.Open Sql,Con_Book
%>
<!--#include file="../ManagerMenu.asp"-->
<form name="form1" method="post" action="book_infoControl.asp">
<input type=Hidden name="Action" value="Update">
<input type=Hidden name="camera_ID" value=<%=rs_book("camera_ID")%>>
本想把代码全发上来 可是字符过多 提示有语法错误 我也没检查出来
camera_ID=request("camera_ID") '取得BookManager.asp传送的图书编号
Set con_Book=Server.CreateObject("ADODB.Connection")
con_Book.Open "DSN=DigitalCamerasSource;uid=sa;pwd=;"
Set rs_Book=Server.CreateObject("ADODB.Recordset")
rs_book.CursorType=adOpenStatic
sql="select * from camera_Info B,manufacturer P where(B.Press_ID=P.Press_ID)"
sql=sql&"and (camera_ID="&camera_ID&")"
rs_book.Open Sql,Con_Book
%>
<!--#include file="../ManagerMenu.asp"-->
<form name="form1" method="post" action="book_infoControl.asp">
<input type=Hidden name="Action" value="Update">
<input type=Hidden name="camera_ID" value=<%=rs_book("camera_ID")%>>
本想把代码全发上来 可是字符过多 提示有语法错误 我也没检查出来
sql="select * from camera_Info B,manufacturer P where(B.Press_ID=P.Press_ID)"
sql=sql&"and (camera_ID="&camera_ID&")"
rs_book.Open Sql,Con_Book
把rs_book.Open Sql,Con_Book改成rs_book.Open Sql,Con_Book,1,3试试
建议在运行SQL语句前添加两句
response.write sql
response.end()
就加在rs_book.Open Sql,Con_Book上面
用来在页面显示执行的SQL语句和传过来的参数
sql="select * from camera_Info B,manufacturer P where(B.Press_ID=P.Press_ID)"
sql=sql&" and (camera_ID="&camera_ID&")"