asp中VBSCRIPT脚本如何调用存储过程?

[qingqingliman]

存储过程如下:
CREATE PROCEDURE my_addhotelorderproc(@orderid char(20),
@memo varchar(255)=NULL,
@ordertype char(1)=1,
@ordertime datetime,
AS

INSERT INTO orderinfo
(orderid, memo, ordertype, ordertime) values
(@orderid, @memo, @ordertype, @ordertime)

RETURN
GO

然后我调用如下,有错误:
orderid=trim(Request.Form("orderid"))
memo=trim(Request.Form("memo"))

conn.EXECUTE my_addhotelorderproc orderid, memo, DEFAULT, Now

conn.Close
set conn=nothing

错误类型：
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/edao/htlorder.asp, 第 44 行, ? 34 ?

[子陌红尘]

sql = "EXECUTE my_addhotelorderproc " &orderid&",'"&memo&"'...
conn.Execute(sql)

[zjcxc]

楼主搞错了用法, 用法是:
conn.EXECUTE "要执行的sql语句"

所以1楼的方法才是对的.