help !!!!
请问下面这段代码有什么错误吗?!<%
set rs=server.createobject("adodb.recordset")
sql="select * from Job_ILeag inner join Job_resume on ILeag_id=rsm_ILeagid where 1=1"
if area<>" " then sql=sql&" and rsm_jobarea1='"&area&"' or rsm_jobarea2='"&area&"' "
if jobclass<>" " then sql=sql&" and rsm_job1='"&jobclass&"' or rsm_job2='"&jobclass&"' "
if sex<>" " then sql=sql&" and ILeag_sex='"&sex&"' "
if age<>" " then sql=sql&"and ILeag_age='"&age&"' "
if xueli<>" " then sql=sql&"and ILeag_schrec='"&xueli&"' "
if workstate<>" " then sql=sql&"and rsm_chara='"&workstate&"' "
response.write sql
rs.open sql,conn,1,1 //此为第22行
%>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/findjob/search_person_show.asp, 第 22 行