ktrinad Posted August 31, 2006 Share Posted August 31, 2006 By: vivek srinivasan - viveksrinivasan type casting problem 2003-09-17 09:04 in the query: select * from sqldiscount where store_id='$P{storepar}' and tran_date>='2003-08-01' and tran_date<='2003-08-25' order by d_disamt desc I get the following error when compiling java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC][sqlServer]Error converting data type varchar to numeric. the store_id is of type integer.Is there any way of overcoming this! By: Sachin Aggarwal - sk_aggarwal RE: type casting problem 2003-09-19 01:00 have u declared parameter storepar as java.lang.Integer ?? I guess this might be the problem Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now