自动编号 ACCESS

Question

delsql="select * from lifeng_mold where no=" & StudentNum若studentnum是string型：
delsql="select * from lifeng_mold where no=" & cint(StudentNum)

Answer 1

delsql="select * from lifeng_mold where no=" & StudentNum

Answer 2

delsql="select lifeng_mold.no as a,lifeng_mold.* from lifeng_mold where no=" & StudentNum
response.write(rs.fields("a"))

Answer 3

明明有记录，却显示“NO”
<%
set conn0=server.CreateObject("adodb.connection")
conn0.open "dsn=mold_dsn;uid=;pwd=;"
dd="select * from lifeng_mold where version='1'"
set rs0=conn0.execute(dd)
StudentNum=rs0.Fields.Item("no").Value
response.write(studentnum)

set conn=server.CreateObject("adodb.connection")
conn.open "dsn=mold_dsn;uid=;pwd=;"
delsql="select * from lifeng_mold where no="&StudentNum
set rs=conn.execute(delsql)
if not rs.eof then
response.write("ok")
'studentnum1=rs.Fields.Item("no").Value
'response.write(studentnum1)
else
response.write("no")
end if
%>

Answer 4

set conn=server.CreateObject("adodb.connection")
conn.open "dsn=mold_dsn;uid=;pwd=;"
delsql="select * from lifeng_mold where no="&StudentNum
set rs=server.createobject("adodb.recordset")
rs.open delsql,conn
if not rs.eof then
response.write("ok")
'studentnum1=rs.Fields.Item("no").Value
'response.write(studentnum1)
else
response.write("no")
end if