• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Native query issue

 
michael haithcock
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am forced to use a native query on a multi table select because of a relationship that is not enforced on the database.

The query works fine in a query analyzer, but within the list that is returned, one of the columns is truncated.

I am trying to return a participants ssn (defined as varchar(9)), why does it only return the first number?

Here is the code:



Please help.

Thank you

Mike

 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Is that pulling out the String, or just the first character of the String?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic