Error converting data type varchar to smallint.

Hi,

I have been getting this error for hours, when i try to do a database insert.

I am not trying to convert varchar to smallint.

I have a stored procedure with params like this at the top:

@PasswordQuestion                              varchar(150),
@PasswordAnswer                              nvarchar(150),
@WebsiteDiscoveryMethodCode                        smallint,
@EmployerID                              char(35)

I do not know why I get this error... soooo frustrating.. can anyone explain why this error would erroneously happen?

-ws
LVL 1
Westside2004Asked:
Who is Participating?
 
paeloCommented:
Show the rest of your proc, in particular youre insert statement.  It's kind of hard to tell with just the parameter information.

-Paul.
0
 
Westside2004Author Commented:
turned out I was missing a parameter.... lol..

I call the proc from the app and i was not passing in a required param... my bad

-ws
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.