Jump to content

type casting problem

Recommended Posts

By: vivek srinivasan - viveksrinivasan

type casting problem

2003-09-18 07:55

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: Chuck Deal - cdeal

RE: type casting problem

2003-09-18 08:14

yeah, remove the quotes around the $P!{storepar}

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...