UC知道ASP运行过程中的“缺少对象: ''”问题
来源：百度知道 编辑：UC知道 时间：2024/05/10 10:25:22
================================================================
dim id,name,sex,chamber,phone_number,qq,mobile_phone,intro,db,str,rs
id=trim(request.form("ID"))
name=trim(request.form("name"))
sex=trim(request.form("sex"))
chamber=trim(request.form("chamber"))
phone_number=clng(request.form("phone_number"))
qq=trim(request.form("QQ"))
mobile_phone=trim(request.form("mobile_phone"))
intro=trim(request.form("intro"))
if id<>"" and name<>"" and sex<>"" and chamber<>"" then
set db=server.createobject("ADODB.connection")
db.open "Dsn=class_data"
str="select * from classmate where student_ID='"&id&"' and classmate_name='"&name&"' and sex='"&sex&"'"
set rs=db.execute(str
dim id,name,sex,chamber,phone_number,qq,mobile_phone,intro,db,str,rs
id=trim(request.form("ID"))
name=trim(request.form("name"))
sex=trim(request.form("sex"))
chamber=trim(request.form("chamber"))
phone_number=clng(request.form("phone_number"))
qq=trim(request.form("QQ"))
mobile_phone=trim(request.form("mobile_phone"))
intro=trim(request.form("intro"))
if id<>"" and name<>"" and sex<>"" and chamber<>"" then
set db=server.createobject("ADODB.connection")
db.open "Dsn=class_data"
str="select * from classmate where student_ID='"&id&"' and classmate_name='"&name&"' and sex='"&sex&"'"
set rs=db.execute(str
str="insert into classmate (student_ID,classmate_name,sex,chamber_number,chamber_phone,QQ,mobile_phone,number_intro)
values('"&id&"','"&name&"','"&sex&"','"&chamber&"',"&phone_number&",'"&qq&"','"&mobile_phone&"','"&intro&"')"
你这里有个换行,这句把所有换行都去掉.
str="insert into classmate (student_ID,classmate_name,sex,chamber_number,chamber_phone,QQ,mobile_phone,number_intro) values('"&id&"','"&name&"','"&sex&"','"&chamber&"',"&phone_number&",'"&qq&"','"&mobile_phone&"','"&intro&"')"