File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to Append special character Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to Append special character" Watch "How to Append special character" New topic
Author

How to Append special character

bobby reddy
Greenhorn

Joined: Nov 05, 2007
Posts: 27
Hello everyone,
How can we append * in front of County field?

strSQL = " SELECT DISTINCT" +
" a.id pkey, " + //DISTINCT
" d_a_lookup.get_gis_type(a.id) gisType, " +
" a.id ID, " +
" d_a_lookup.get_country_desc(acCountry.country_code) country " +
" FROM arc a, d_f_arc b " +

", arcCountry acCountry ";

Thanks,
Bobby
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61103
    
  66

Please take the time to choose the correct forum for your posts. This forum is for questions on JSP.

This post has been moved to a more appropriate forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30392
    
150

Bobby,
It sounds like you want to concatenate a character to a field. The function/syntax for this varies by database. Which database are you using?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Originally posted by bobby reddy:
Hello everyone,
How can we append * in front of County field?

strSQL = " SELECT DISTINCT" +
" a.id pkey, " + //DISTINCT
" d_a_lookup.get_gis_type(a.id) gisType, " +
" a.id ID, " +
" d_a_lookup.get_country_desc(acCountry.country_code) country " +
" FROM arc a, d_f_arc b " +

", arcCountry acCountry ";

Thanks,
Bobby


Your query doesn't have a "county" field/column and the "country" field/column is being passed to a function. So you need to provide more information.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to Append special character