<!--#include file=../include/config.asp-->
<!--#include file=../include/conn_newhouse.asp-->
<%
        dim rs,sql,jj_bz,bus
	
        bus=request("bus")
	bus=replace(bus," ","&nbsp;")
        bus=replace(bus,chr(13)&chr(10),"<Br>")

        jj_bz=request("jj_bz")
	jj_bz=replace(jj_bz," ","&nbsp;")
        jj_bz=replace(jj_bz,chr(13)&chr(10),"<Br>")
	

	sql="select * from [house_new] where id=" & request("id")
	set rs=server.createobject("adodb.recordset")
        rs.open sql,conn,3,3

        rs("house_name")=request("house_name")
        rs("kfs")=request("kfs")
        rs("kfs_http")=request("kfs_http")
        rs("qy")=request("qy")
        rs("address")=request("address")
        rs("traffic")=request("traffic")
        rs("house_lx")=request("house_lx")
        rs("mj")=request("mj")
        rs("first_pay")=request("first_pay")
        rs("jun_pay")=request("jun_pay")
        rs("xk")=request("xk")
        rs("pic")=request("pic")
        rs("jj_bz")=jj_bz
        rs("zt")=request("zt")
        rs("sell_tel")=request("sell_tel")
        rs("sell_address")=request("sell_address")
        rs("fax")=request("fax")
        rs("email")=request("email")
        rs("man")=request("man")
        rs("color")=request("color")
        rs("bus")=bus

        rs.update

response.write "newhouse修改成功"
%>
<%
        connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
	connstr = connstr & Server.MapPath("../mdb/view.asp")
	set conn=Server.CreateObject("AdoDb.Connection")
	conn.Open connstr

	sql="select * from [house_new] where id=" & request("id")
	set rs=server.createobject("adodb.recordset")
        rs.open sql,conn,3,3

        rs("house_name")=request("house_name")
        rs("jun_pay")=request("jun_pay")
        rs("color")=request("color")

        rs.update

response.write "view修改成功!"
%>
<!--#include file=../include/foot.asp-->