dim title,article,user_name,write_back,pre_article_id,write_back_count,hits,ip
title=trim(request.Form("title"))
article=trim(request.Form("article"))
user_name=session("name")
write_back=0
pre_article_id=0
write_back_count=0
hits=0
ip=request.ServerVariables("remote_addr")
dim sql
sql="insert into article(title,article,user_name,write_back,pre_article_id,write_back_conut,hits,ip,submit_date)"
sql=sql & "values('" & title &"','" & article & "','" & user_name & "','" & write_back & ","& pre_article_id & "," & write_back_count & ","& hits & ",'"& ip &"','" & date() & "')"
conn.Execute(sql)
conn.Close
response.Redirect"list_title.asp"

两个sql最好分别命名

有没有问题，你把它 response.write 一下，然后到DBMS里面执行一下不就知道了！

--我是一只小尾巴~咿呀咿呀哟....哎呀不要咬我不能吃的！