杭州交通信息网模拟退火算法应用:ASP的问题
来源：百度文库 编辑：杭州交通信息网 时间：2024/05/03 05:54:40
<!--#include file=conn.asp-->
<%
dim rs,strsql
set rs=Server.CreateObject("ADODB.RecordSet")
strsql="select borrowinfo.user_id,borrowinfo.book_id,borrowinfo.submit_date,borrowinfo.return,book.booknumber from borrowinfo,book where book.book_id=borrowinfo.book_id "
rs.open strsql,conn,0,2
rs.addNew
rs("borrowinfo.user_id")=request.form("user_id")
rs("borrowinfo.book_id")=request.form("book_id")
rs("borrowinfo.submit_date")=Now()
rs("borrowinfo.return")=false
rs("book.booknumber")=booknumber-1
rs.Update
Response.redirect("")
rs.close
set rs=nothing
set conn=nothing
%>
请问这样写有什么错误?
<%
dim rs,strsql
set rs=Server.CreateObject("ADODB.RecordSet")
strsql="select borrowinfo.user_id,borrowinfo.book_id,borrowinfo.submit_date,borrowinfo.return,book.booknumber from borrowinfo,book where book.book_id=borrowinfo.book_id "
rs.open strsql,conn,0,2
rs.addNew
rs("borrowinfo.user_id")=request.form("user_id")
rs("borrowinfo.book_id")=request.form("book_id")
rs("borrowinfo.submit_date")=Now()
rs("borrowinfo.return")=false
rs("book.booknumber")=booknumber-1
rs.Update
Response.redirect("")
rs.close
set rs=nothing
set conn=nothing
%>
请问这样写有什么错误?
strsql="select borrowinfo.user_id,borrowinfo.book_id,borrowinfo.submit_date,borrowinfo.return,book.booknumber from borrowinfo,book where book.book_id=‘borrowinfo.book_id '"
rs.open strsql,conn,1,3
这样试试吧~！！