|
|
|
|
＜html＞＜head＞
＜title＞authoredit.asp＜/title＞
＜/head＞＜body bgcolor=#FFFFFF＞
＜%
' 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 amp; where AU_ID= amp; 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
%＞
＜body＞
＜form name=myauthor action=authoreditrespond.asp method=POST＞
＜input type=hidden name=id value=＜%=form_auid%＞＞
＜p＞Author ID: ＜%=form_auid%＞＜/p＞
＜p＞ Author Name:
＜input type=TEXT name=name value=＜%=form_author%＞＞＜/p＞
＜p＞ Year Born:
＜input type=TEXT name=year value=＜%=form_year_born%＞＞＜/p＞
＜p＞ ＜input type=SUBMIT＞ ＜/p＞
＜/formgt |
|
|
