非常奇怪的问题,为什么得不到ID值?大家帮忙看看,在线等!!!解决问题马上结贴
在这段程序中添加一条新的记录后,为什么用rs("bookid")得不到这条记录的ID值?错在哪里,而在别一段程序中却能得到ID值?
<!--在下面这段中,行20,fname = rs("bookid")为什么返回的值是空?-->
<!--#include file="../Conn.asp"-->
<%
dim bookid,bookname,bookzz,bookchuban
bookname=trim(request("bookname")) '书名
bookzz=trim(request("bookzz")) '作者
bookchuban=trim(request("bookchuban")) '出版社
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from GB_Books",conn,1,3
rs.AddNew
rs("bookname")=bookname
rs("bookzz")=bookzz
rs("bookchuban")=bookchuban
rs.Update
dim fname,folder,filepath,sql1,mb_code,fout,fso
'生成HTML文件名,建立文件夹,指定文件路径
fname = rs("bookid")
folder = "/Html/"&date()&"/"
filepath = folder&fname&".html"
'打开模板代码,并将其中特殊代码转变为接受值
sql1="select m_id,m_html from GB_Templet where m_id=1"
set rs1=Server.CreateObject("adodb.recordset")
rs1.open sql1,conn,1,1
mb_code=rs1("m_html")
rs1.close
set rs1=nothing
conn.close
set conn=nothing
mb_code=replace(mb_code,"$bookname$",bookname)
mb_code=replace(mb_code,"$bookzz$",bookzz)
mb_code=replace(mb_code,"$bookchuban$",bookchuban)
'生成HTML页面
Set fso = Server.CreateObject("Scripting.FileSystemObject")
if (fso.FolderExists(Server.MapPath(folder))) then
'判断如果存在就不做处理
else
'判断如果不存在则建立新文件夹
fso.CreateFolder(Server.MapPath(folder))
end if
Set fout = fso.CreateTextFile(Server.MapPath(filepath))
fout.WriteLine mb_code
fout.close
'rs.Close
set rs=nothing
response.Write "<script language=javascript>alert('添加成功!');window.location.reload('addBook.asp')</script>"
response.End
%>
<!--下面这段中却可以能正常返回?奇怪!行20 fname = rs("c_id")-->
<!--#include file="conn.asp" -->
<%'接受传递值
c_title=request.form("c_title")
c_content=request.form("c_content")
%>
<%'将接受值及路径保持至数据库表
sql = "Select * from c_news"
Set rs = Server.CreateObject ("ADODB.Recordset")
rs.Open sql,conn,3,2
rs.addnew
rs("c_title")=c_title
rs("c_content")=c_content
rs.update
%>
<!--#include file="lib.asp" -->
<%'生成HTML文件名,建立文件夹,指定文件路径
fname = rs("c_id")
folder = "Html/"&date()&"/"
filepath = folder&fname&".html"
rs.close
Set rs = Nothing
%>
<%'打开模板代码,并将其中特殊代码转变为接受值
sql1="select m_id,m_html from c_moban where m_id=1"
set rs1=Server.CreateObject("adodb.recordset")
rs1.open sql1,conn,1,1
mb_code=rs1("m_html")
rs1.close
set rs1=nothing
conn.close
set conn=nothing
c_title=htmlencode(c_title)
c_content=htmlencode(c_content)
mb_code=replace(mb_code,"$bookname$",now())
mb_code=replace(mb_code,"$bookzz$",c_title)
mb_code=replace(mb_code,"$isbn$",c_content)
%>
<%'生成HTML页面
Set fso = Server.CreateObject("Scripting.FileSystemObject")
if (fso.FolderExists(Server.MapPath(folder))) then
'判断如果存在就不做处理
else
'判断如果不存在则建立新文件夹
fso.CreateFolder(Server.MapPath(folder))
end if
Set fout = fso.CreateTextFile(Server.MapPath(filepath))
fout.WriteLine mb_code
fout.close
%>
文章添加成功!