set cm=Server.CreateObject("Adodb.Command") Cm.CommandType=4 Cm.ActiveConnection=conn Cm.CommandText="insert_e_subscribe" Cm.parameters(1)=ec_id Cm.Parameters(6)=es_email set rs=Cm.Execute()参数传递出错哦!
不好意思上面那个写错了 set cm=Server.CreateObject("Adodb.Command") Cm.CommandType=4 Cm.ActiveConnection=conn Cm.CommandText="insert_e_subscribe" Cm.parameters(1)=ec_id Cm.Parameters(2)=es_email set rs=Cm.Execute()参数传递出错哦!先检查存储过程是否出错??
还是不行
Cm.CommandType=4
Cm.ActiveConnection=conn
Cm.CommandText="insert_e_subscribe"
Cm.parameters(1)=ec_id
Cm.Parameters(6)=es_email
set rs=Cm.Execute()参数传递出错哦!
set cm=Server.CreateObject("Adodb.Command")
Cm.CommandType=4
Cm.ActiveConnection=conn
Cm.CommandText="insert_e_subscribe"
Cm.parameters(1)=ec_id
Cm.Parameters(2)=es_email
set rs=Cm.Execute()参数传递出错哦!先检查存储过程是否出错??
我直接用.CommandText ="insert_e_subscribe "&ec_id&",'"&email&"'"了
不设参数的类型了
但我不知道为什末错了.CommandType =adCmdStoredProc '有它也报错.Parameters.append mycom.CreateParameter ("ec_id",adInteger,adParamInput,4,ec_id)
.Parameters.append mycom.CreateParameter ("es_email",adVarWChar,adParamInput,400,email)