Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Append special character

 
bobby reddy
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64610
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic