case 1000 strcommand="insert into ssjj (id_atical,title,content,Author,label,time) values ('"& id1 &"','"& title &"','"& content &"','"& Author &"','"& label &"','"& time1 &"')" case 1001 strcommand="insert into xxyd (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" case 1002 strcommand="insert into dyzj (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" case 1004 strcommand="insert into ssjj (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" case 1009 strcommand="insert into ycwx (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" case 1013 strcommand="insert into xlyz (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" case 1010 strcommand="insert into jyht (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" case 1012 strcommand="insert into ssxy (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" case 10000 strcommand="insert into ssjj (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')" end select 可以换成select case id1
case 1000
table="ssjj"
case 1001
table="xxyd"……end select然后使用一个语句就可以了strcommand="insert into "&table&" (id_atical,title,content,Author,label,time) values ('"&id1&"','"&title&"','"&content&"','"&Author&"','"&label&"','"&time1&"')"这样岂不是简单明了?程序没运行,估计是你的id1值为空,你可以用Response.Write id1检查下2.response.write ("") response.write ("")javascript每行结束都应该有分号";" |