Question

ASP语法错误 (操作符丢失) 在查询表达式

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

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '(a.s_num*b.stock_v)[gszj]' 中。

<%
Dim RS
Dim RS_numRows

Set RS = Server.CreateObject("ADODB.Recordset")
RS.ActiveConnection = MM_conn_STRING
RS.Source = "select A.id,a.S_num,(a.s_num*b.stock_v)[gszj] from gszj A,stock B where A.stockid = B.stockid"
RS.CursorType = 0
RS.CursorLocation = 2
RS.LockType = 1
RS.Open()

RS_numRows = 0
%>

Answer 1

RS.Source = "select A.id,a.S_num,(a.s_num*b.stock_v)[gszj] from gszj A,stock B where A.stockid = B.stockid"
有问题。
ACCESS为列指定别名需要使用AS所以你的语句因该改成
RS.Source = "select A.id,a.S_num,(a.s_num*b.stock_v) as [gszj] from gszj A,stock B where A.stockid = B.stockid"

Answer 2

ASP常用错误类型
http://www.haao.cn/article.asp?id=68&keyword=80040e14

MicrosoftOLEDBProviderforODBCDrivers(0x80040E14)-->sql语句出错(字段名错误,或数据类型不匹配)