调用子时不能使用圆括号

本文介绍了调用子时不能使用圆括号的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个经典的ASP页面，其中包含以下code到尝试parametised查询;

I have a Classic ASP page that contains the following code to attempt a parametised query;

<% Set cmdEmail = Server.CreateObject("ADODB.Command") Set rsEmail = Server.CreateObject("ADODB.Recordset") cmdEmail.CommandText = "SELECT * FROM VWTenantPropertiesResults WHERE ContentID = ?" cmdEmail.CommandType = 1 cmdEmail.ActiveConnection = MM_dbconn_STRING cmdEmail.Parameters.Append cmdEmail.CreateParameter("@ContentID", 3, 1, , request.Form("ContentID")) rsEmail.Open cmdEmail %>

不过，页面现已报告下列错误;

However, the page is now reporting the following error;

无法使用圆括号/welcome/default2.asp，线路436cmdEmail.CreateParameter（@内容识别，3,1，，REQUEST.FORM（内容识别））-------------------------------------------------- --------------------- ^

Cannot use parentheses when calling a Sub /welcome/default2.asp, line 436 cmdEmail.CreateParameter("@ContentID", 3, 1, , request.Form(ContentID)) -----------------------------------------------------------------------^

这是一些bug与ASP或者我需要改变我试图parametised疑问？

Is this some bug with ASP or do I need to change how I attempt parametised queries?

感谢您。

推荐答案

你有没有尝试过删除这些括号？

Did you tried just to remove those parenthesis?

cmdEmail.CreateParameter "@ContentID", 3, 1, , Request.Form("ContentID")

据我记得，当你调用一个函数，并且不使用其返回值总是会发生的。

As far as I remember, that always happens when you call a function and doesn't use its return value.

更新：看来真正的问题是断行：

UPDATE: Seems the real problem is the line break:

cmdEmail.Parameters.Append _ '' note this "_" character cmdEmail.CreateParameter("@ContentID", 3, 1, , Request.Form("ContentID"))