insert record using stored proc returns no error but doesn't inserd record

[Guest]

Hi

I am using SQL server 7.0 and here is my code:

Dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.open "websql"

If conn.state=adStateOpen then
Response.Write("ConnMade : " & conn.state
& "<BR>")
Response.flush
else
Response.Write("not ConnMade : " &
conn.state & "<BR>")
end if
'response.write sql
conn.execute("Insert_Emailseller" &_
" @fname='" & fname & "'," &_
" @lname='" & lname & "'," &_
" @dphone='" & dphone & "'," &_
" @ephone='" & ephone & "'," &_
" @email='" & email & "'," &_
" @comments='" & comments & "'," &_
" @chktrade='" & chktrade & "'," &_
" @chkfinance='" & chkfinance & "'," &_
" @ctime='" & ctime & "'," &_
" @prom='" & prom & "'," &_
" @dealerid='" & dealerid & "'," &_
" @vin='" & vin & "'," &_
" @dateandtime=" & dateandtime)
'conn.ExecuteComplete(sql)
'Response.write("Record inserted. ID number was <b>" &
rs(0) & "</b>.")
'rs.close: set rs = nothing
conn.close: set conn = nothing

and my stored procedure is:
CREATE PROCEDURE dbo.Insert_Emailseller

@fname varchar (50) ,
@lname varchar (50) ,
@dphone int ,
@ephone int ,
@email varchar (50) ,
@comments text ,
@chktrade bit ,
@chkfinance bit ,
@ctime char (10) ,
@prom tinyint ,
@dealerid char (10) ,
@vin varchar (18) ,
@dateandtime datetime
AS
BEGIN
SET NOCOUNT ON
DECLARE @new_emailseller INT
INSERT caremail_leads
(
fname ,
lname ,
dphone ,
ephone ,
email ,
comments ,
chktrade ,
chkfinance ,
ctime ,
prom ,
dealerid ,
vin ,
dateandtime
)
VALUES
(
@fname ,
@lname ,
@dphone ,
@ephone ,
@email ,
@comments ,
@chktrade ,
@chkfinance ,
@ctime ,
@prom ,
@dealerid ,
@vin ,
@dateandtime
)
SELECT @new_emailseller = @@IDENTITY
SELECT new_emailseller = @new_emailseller
END

 

[Alex G]

Shouldn't the stored procedure be using INSERT INTO not just INSERT ??