ASP程序问题。。急!!

来源:百度知道 编辑:UC知道 时间:2024/03/29 18:34:23
请哪位大侠帮小弟解决下这个报错。。非常感谢。!

Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'

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

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

ODBC 驱动程序不支持所需的属性。

/chinese/pwxx.asp,行70

以下是我的代码部分。请参看

sql = "select distinct zb_id,zb_name,zb_date,title,title2,zb_company,zb_baoz,zb_price,jpg_news,zb_jweight from office_info,pnews1,pnews11,ptime where zb_lable = title and zb_lable1 = title1 and deltype=0 "
sql = sql & " and zb_id = pid "
if request("zb_name") <> "" then
sql = sql & " and zb_lable = '"&request("zb_name")&"'"
end if
if request("zb_name1") <> "" then
sql = sql & " and zb_lable1 = '"&request("zb_name1")&"'"
end if
if request("key") <> "&quo

兄弟你第一句就写错了,再看一下报出的错误就知道是关于数据库的问题,你第一句的语句中表的指定不明确你对office_info,pnews1,pnews11,ptime 这些表进行操作可在你的取值和where语句中都没有指明到底是哪张表的字段,所以才有错你可以这么写,示例:
select A.distinct B.zb_id,from office_info A,pnews1 B where A.zb_lable = title and B.zb_lable1 = title1
因为我对你的表结构不了解所以只能写成这样了。

sql = "select distinct zb_id,zb_name,zb_date,title,title2,zb_company,zb_baoz,zb_price,jpg_news,zb_jweight from office_info,pnews1,pnews11,ptime where zb_lable = title and zb_lable1 = title1 and deltype=0 "
里面title,title1是文字把
必须加单引号'

最后一个IF语句没有与之对应的END

把代码都贴出来吧

sql语句肯定有问题