This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Struts and the fly likes How to Convert type in sql or jasper i report Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Frameworks » Struts
Bookmark "How to Convert type in sql or jasper i report" Watch "How to Convert type in sql or jasper i report" New topic
Author

How to Convert type in sql or jasper i report

Kaustubh Sharma
Greenhorn

Joined: Mar 02, 2010
Posts: 28
hi .......

in my sql query i want to change bit type 0 or 1 in values 'Yes' or 'No' but while runnig query below I am getting

Error: Conversion failed when converting the varchar value 'No' to data type bit.

Query:select case casedetails.[re-openindicator] when 1 then 'Yes' when 0 then 'No' else casedetails.[re-openindicator] end from casedetails

Well I am also passing this query to Jasper I report but there also it is converting it into boolean values false or true but I want it as Yes or No...


looking for a sharp Brain to solve my problem ..... please help me out to convert it any side(jasper i report or in sql query)

Thanks in Advance

Kaustubh
 
 
subject: How to Convert type in sql or jasper i report
 
jQuery in Action, 3rd edition