麻烦大佬帮忙看看
在用DW做插入操作时,出现:[Microsoft][ODBC Microsoft Access 驱动程序] FROM 子句语法错误。
提示13行即:Set Recordset1 = Recordset1_cmd.Execute此句有错
完整代码:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_order_STRING
Recordset1_cmd.CommandText = "SELECT * FROM Order"
Recordset1_cmd.Prepared = true
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
顾客编号: <label></label> <input id="顾客编号" name="顾客编号" type="text" />
菜品编号: <input id="菜品编号" name="菜品编号" type="text" />
口味备注: <input id="口味备注" name="口味备注" type="text" />
</form> <% Recordset1.Close() Set Recordset1 = Nothing %>