needact.asp

一个专业的房地产门户网站

<!--#include file="conn.asp" -->
<!--#include file="user_pass.asp"-->
<% city="衡水"
want=Request("want")
dd=Request("dd")
tx=Request("tx")
uid=Request("uid")
name1=Request("name")
square=Request("square")
price=Request("price")
zx=Request("zx")
lc=Request("lc")
person=Request("person")
phone=Request("phone")
email=Request.Form("email")
ip=Request.servervariables("remote_addr")
date1=Request("date1")
content1=Request("content1")
quansh=Request("quansh")
if isnumeric(price)=true then
  if content1="" then
     content1=" "
  end if
  if date1="" then
     date1="无"
  end if
  if name="" then
     name=" "
  end if 
  if square="" then 
     square=" "
  end if  

sql = "INSERT into need (City,Diduan,uid,Taox,Lc,zx,Mianj,Jiag,Xiaoqm,qiu,Tele,email,ip, content, D, Contperson ,quansh) VALUES ('"& city &"','"& dd &"','"& uid &"','"& tx &"','"& lc &"','"& zx &"','"& square &"','"& price &"','"& name1 &" ','"& want &"','"& phone &"','"& email &"','"& ip &"','"& content1 &"', '"& date1 &"','"& person &"','"& quansh &"')"
'response.write(sql)
'response.end
conn.Execute(sql)
%> 
<script language=vbs>
<!--
        MsgBox "您的信息登记成功!"
        window.location.href="user_need.asp"
-->
</script> 
<% else %>
<script language=vbs>
<!--
        MsgBox "你输入的价格或租金不对,请检查!"
        window.location.href="user_need.asp"
-->
</script>
<% end if %>