Error converting data type varchar to int.

baysaa · #1 (**permalink**) March 13th, 2008, 12:33 PM

Hi! I wrote a simple stored procedure to add a few fields into a MsSQL table:

Code:

INSERT INTO dbo.xyz769_Blog_01_Comments
                        (Blog_01ID, Blog_01_Title, Username, Comment_Content, Email)
VALUES      (@Blog_01ID, @Blog_01_Title, @Username, @Comment_Content, @Email)

But whenever i try to insert data thru an ASP page i get the following error:

Code:

Microsoft OLE DB Provider for SQL Server error '80040e07'

Error converting data type varchar to int.

/anti_sql/pages/blog_01/blog_item.asp, line 73

Line 73 on blog_item.asp is just my execution statement which is the following:

Code:

rsEnterRecord_cmd.Execute

I tested to see which parameter was causing the problem, and after I went thru each one, I found out that when I enabled the @Email parameter it gives me this error.

My Parameters are created on the ASP page through following statements:

Code:

rsEnterRecord_cmd.Parameters.Append rsEnterRecord_cmd.CreateParameter("@Blog_01ID", 3, 1)
rsEnterRecord_cmd.Parameters.Append rsEnterRecord_cmd.CreateParameter("@Blog_01_Title", 200, 1, 200)
rsEnterRecord_cmd.Parameters.Append rsEnterRecord_cmd.CreateParameter("@Username", 200, 1, 50)
rsEnterRecord_cmd.Parameters.Append rsEnterRecord_cmd.CreateParameter("@Comment_Content", 200, 1, 255)
rsEnterRecord_cmd.Parameters.Append rsEnterRecord_cmd.CreateParameter("@Email", 200, 1, 200)

In the database table:
Blog_01ID is Integer
Blog_01_Title is nvarchar
Email is nvarchar
Comment_Content is nvarchar
Username is nvarchar

I really don't see where the problem is, and I've run out of ideas, please help ....

om_prakash · #2 (**permalink**) March 17th, 2008, 12:56 AM

Hi,

What is the data types of fields in dbo.xyz769_Blog_01_Comments table?

Om Prakash

Need to download code?

Navigation