|
 |
aspx thread: Convert Error: Error converting data type varchar to int
Message #1 by "J Donahue" <jdonahue@f...> on Thu, 8 Aug 2002 21:38:26
|
|
Hi all. I'm playing with the convert function in a stored procedure but
I keep getting the error "Error converting data type varchar to int". I
have a stored procedure as follows:
CREATE PROCEDURE dbo.my_test
@myvar Varchar(50),
@date1 VarChar(10) Output,
@date2 VarChar(10) Output
AS
Set NOCOUNT OFF
SELECT @date1=Convert(varchar(10),tUsers.userdate,103),
@date2 = Convert(varchar(10),tBranches.branchdate,103)
FROM tUsers
INNER JOIN tBranches ON tBranches.BranchID = tUsers.BranchID WHERE
myvarfield=@myvar
In my code, my parameters are as follows:
Date1 = objCommand.Parameters.Add("Date1", OleDbType.VarChar, "10")
Date1.Direction = ParameterDirection.Output
Date2 = objCommand.Parameters.Add("Date2", OleDbType.VarChar, "10")
Date2.Direction = ParameterDirection.Output
Can anyone tell me what I'm doing wrong?? Thank you
Message #2 by headley@c... on Fri, 9 Aug 2002 09:16:43 -0400
|
|
In your Where statement, what is the datatype of myvarfield? If it's datatype is int, then it is trying
to convert your variable @myvar from a varchar to an int in order to perform the where clause.
-----Original Message-----
From: J Donahue [mailto:jdonahue@f...]
Sent: Thursday, August 08, 2002 5:38 PM
To: ASP+
Subject: [aspx] Convert Error: Error converting data type varchar to int
Hi all. I'm playing with the convert function in a stored procedure but
I keep getting the error "Error converting data type varchar to int". I
have a stored procedure as follows:
CREATE PROCEDURE dbo.my_test
@myvar Varchar(50),
@date1 VarChar(10) Output,
@date2 VarChar(10) Output
AS
Set NOCOUNT OFF
SELECT @date1=Convert(varchar(10),tUsers.userdate,103),
@date2 = Convert(varchar(10),tBranches.branchdate,103)
FROM tUsers
INNER JOIN tBranches ON tBranches.BranchID = tUsers.BranchID WHERE
myvarfield=@myvar
In my code, my parameters are as follows:
Date1 = objCommand.Parameters.Add("Date1", OleDbType.VarChar, "10")
Date1.Direction = ParameterDirection.Output
Date2 = objCommand.Parameters.Add("Date2", OleDbType.VarChar, "10")
Date2.Direction = ParameterDirection.Output
Can anyone tell me what I'm doing wrong?? Thank you
|
|
|
View Cart
