调用子时不能使用圆括号 [英] Cannot use parentheses when calling a Sub

问题描述

我有一个经典的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，线路436
cmdEmail.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"))

这篇关于调用子时不能使用圆括号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！