是怎么原因呀！求解呀！在线等！拜托了！

[onlong]

select user.userid,registerdate,IndustryclassId,companyname,produce,produce_en,contractor,instruction,instruction2,instruction3,mude,youbian,nb,ynnb,infodate,email,address,city,type,tel,fax,type_qylb,type_qylb1,homeurl from user,company where user.IndustryTypeId =1 and user.userid=company.userid and company.type like '**' order by company.instruction ,abs(left(company.instruction2,2))
'========================================================================================
Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

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

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

[Microsoft][ODBC Microsoft Access Driver] FROM 子句语法错误。

[xiaosaye]

from [user]

[onlong]

我用的是ACCESS数据库！实验过了！行呀！

[onlong]

我用的是ACCESS数据库！实验过了!不行呀！

[xiaosaye]

你到底是行还是不行啊

[onlong]

不行啊

[lirong]

company.type like '**'
改为

company.type like '%"**"%'

[itzhiren]

还是一样的错误吗？

[chjpeng]

代码较长时注意不能直接回车换行，ASP会认为是另一段程序，造成提示'END'错误
同一行代码可以换行的结尾使用_连接

[masling]

from user,company 可以有两个吗?

[masling]

是可以的,刚才错误了。

[onlong]

If Request("IndustryClassId") <> "" then strcompany="select * from [user] a,company b where a.userid=b.userid and a.IndustryClassId ="&Request("IndustryClassId") & orderby
'==================================
f request("yntuan")<>"" then yntuan=request("yntuan")
Set rscompany = Server.CreateObject("ADODB.RecordSet")
rscompany.PageSize =Pagesize
rscompany.CursorLocation=3

rscompany.Open strcompany,Conn,3,1,2
这是我的完整语句!
rscompany.Open strcompany,Conn,3,1,1
提示:
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 2
rscompany.Open strcompany,Conn,3,1,2
提示:
[Microsoft][ODBC Microsoft Access Driver] FROM 子句语法错误
头痛呀！帮我看看！

[xiaosaye]

If Request("IndustryClassId") <> "" then strcompany="select * from [user] a,company b where a.userid=b.userid and a.IndustryClassId ="&Request("IndustryClassId") & "order by
字段名"

[onlong]

orderby是我的一个复值语句！