一聚教程网:一个值得你收藏的教程网站

热门教程

数据库记录的表格显示,编辑与更新

时间:2022-06-30 10:03:35 编辑:袖梨 来源:一聚教程网


authoredit.asp

<%
' My ASP program that given an AU_ID, allows editing a record
myDSN="DSN=Student;uid=student;pwd=magic"
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
form_ID=request.querystring("which")
sqltemp="select * from authors "
sqltemp=sqltemp & " where AU_ID=" & form_id
set rstemp=conntemp.execute(sqltemp)
form_auID=rstemp("AU_ID")
form_author=rstemp("Author")
form_year_born=rstemp("Year_Born")
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%>



Author ID: <%=form_auid%>


Author Name:


Year Born:




热门栏目