<!--#include file="db.asp"--> <style> <!-- td,body,table {font-family: "宋体"; font-size: 12px} A:link {text-decoration: underline; color: #000088;} A:visited {text-decoration: underline; color: #000088;} A:active {text-decoration: underline;color: #FF0000;} A:hover {text-decoration: underline; color: #FF0000;}

.nl { font-family: "宋体"; font-size: 12px} A.nl:link {text-decoration: none; color: #000000;} A.nl:visited {text-decoration: none; color: #000000;} A.nl:active {text-decoration: none;color: #000000;} A.nl:hover {text-decoration: none; color: #000000;}

.white {font-family: "宋体"; font-size: 12px} A.white:link {text-decoration: underline; color: #ffffff;} A.white:visited {text-decoration: underline; color: #ffffff;} A.white:active {text-decoration: underline;color: #ffffff;} A.white:hover {text-decoration: underline; color: #ffffff;}

--> </style>

<%

yonghuming= request("yonghuming") mima= request("mima") tishi= request("tishi") wenti= request("wenti") xingming= request("xingming") lianxiren= request("lianxiren") dianhua= request("dianhua") dizhi= request("dizhi") place= request("place") dxcity= request("dxcity") youbian= request("youbian") chuanzhen= request("chuanzhen") xinxiang= request("xinxiang") jianjie= request("jianjie")

exec="select * from js_zhaoping1 where yonghuming='"&yonghuming&"'" exec="select * from js_zhaopin where xingming='"&xingming&"'" set rs=server.createobject("adodb.recordset") set rs1=server.CreateObject("adodb.recordset") rs.open exec,conn,1,1

if not (rs.eof and rs.bof ) then if not (rs1.eof and rs1.bof ) then response.write "您的用户名已经被注册&nbsp;<a href=qiye.asp>重新注册</a>" response.end else qq="insert into js_zhaoping1(yonghuming,mima,tishi,wenti) values( '"+ yonghuming+"','"+mima+"','"+tishi+"','"+wenti+"')"

qq1="insert into js_zhaopin(xingming,lianxiren,dianhua,dizhi,place,dxcity,youbian,chuanzhen,xinxiang,jianjie) values( '"+xingming+"','"+lianxiren+"','"+dianhua+"','"+dizhi+"','"+place+"','"+dxcity+"','"+youbian+"','"+chuanzhen+"','"+xinxiang+"','"+jianjie+"' )" conn.execute qq

conn.execute qq1 set rs=nothing set rs1=nothing

session("yonghuming")=request("yonghuming") response.write "恭喜"&yonghuming&"注册成功!&nbsp;你的密码是"&mima&"你要牢记!&nbsp;你的公司名称"&xingming&"!" end if

end if

%>

</th> <th width="636" scope="col"><!--#include file="zhaopingzhuce.asp"--></th> </tr>

</table>

没有毛病

忘数据库里这个js_zhaopin这个表里存不了信息
qq1="insert into js_zhaopin(xingming,lianxiren,dianhua,dizhi,place,dxcity,youbian,chuanzhen,xinxiang,jianjie) values( '"+xingming+"','"+lianxiren+"','"+dianhua+"','"+dizhi+"','"+place+"','"+dxcity+"','"+youbian+"','"+chuanzhen+"','"+xinxiang+"','"+jianjie+"' )"
conn.execute qq     

它怎么说啊

<!--#include file="db.asp"--> <style> <!-- td,body,table {font-family: "宋体"; font-size: 12px} A:link {text-decoration: underline; color: #000088;} A:visited {text-decoration: underline; color: #000088;} A:active {text-decoration: underline;color: #FF0000;} A:hover {text-decoration: underline; color: #FF0000;}

.nl { font-family: "宋体"; font-size: 12px} A.nl:link {text-decoration: none; color: #000000;} A.nl:visited {text-decoration: none; color: #000000;} A.nl:active {text-decoration: none;color: #000000;} A.nl:hover {text-decoration: none; color: #000000;}

.white {font-family: "宋体"; font-size: 12px} A.white:link {text-decoration: underline; color: #ffffff;} A.white:visited {text-decoration: underline; color: #ffffff;} A.white:active {text-decoration: underline;color: #ffffff;} A.white:hover {text-decoration: underline; color: #ffffff;}

--> </style>

<%

yonghuming= request("yonghuming") mima= request("mima") tishi= request("tishi") wenti= request("wenti") xingming= request("xingming") lianxiren= request("lianxiren") dianhua= request("dianhua") dizhi= request("dizhi") place= request("place") dxcity= request("dxcity") youbian= request("youbian") chuanzhen= request("chuanzhen") xinxiang= request("xinxiang") jianjie= request("jianjie")

exec="select * from js_zhaoping1 where yonghuming='"&yonghuming&"'" exec="select * from js_zhaopin where xingming='"&xingming&"'" set rs=server.createobject("adodb.recordset")

rs.open exec,conn,1,1

if not (rs.eof and rs.bof ) then

response.write "您的用户名已经被注册&nbsp;<a href=qiye.asp>重新注册</a>" response.end else qq="insert into js_zhaoping1(yonghuming,mima,tishi,wenti) values( '"+ yonghuming+"','"+mima+"','"+tishi+"','"+wenti+"')" qqa="insert into js_zhaopin(xingming,lianxiren,dianhua,dizhi,place,dxcity,youbian,chuanzhen,xinxiang,jianjie) values( '"+xingming+"','"+lianxiren+"','"+dianhua+"','"+dizhi+"','"+place+"','"+dxcity+"','"+youbian+"','"+chuanzhen+"','"+xinxiang+"','"+jianjie+"' )" conn.execute qqa

conn.execute qq

set rs=nothing

session("yonghuming")=request("yonghuming") response.write "恭喜"&yonghuming&"注册成功!&nbsp;你的密码是"&mima&"你要牢记!&nbsp;你的公司名称"&xingming&"!" end if

%>

</th> <th width="636" scope="col"><!--#include file="zhaopingzhuce.asp"--></th> </tr>

</table> 你给我看看这个吧， 它的错误代码是

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e57'

[Microsoft][ODBC SQL Server Driver][SQL Server]将截断字符串或二进制数据。

/9999/qiyechenggong.asp，行57 帮我看看改好好吗，

哪行出的错啊

conn.execute qqa
这个呀

没有qqa

是呀

select中的语句好像错了
exec="select * from js_zhaoping1 where yonghuming='"&amp;yonghuming&amp;"'"
中最后的"&amp;"是什么意思啊！！！