Re: ResultSet Column to string by delimiter such as ','

Article View: borland.public.jbuilder.java.language

Article #8543

Back to borland.public.jbuilder.java.language Previous Next

#8543

From: Torsten Welches
Date: Tue, 13 Mar 2001 08:48

28 lines
1431 bytes

Stephen,

this is from the top of my head and my contain syntax flaws:

StringBuffer buf = new StringBuffer();
while (rslt.next()) {
  if (rslt.length() > 0) {
    buf.append(',');  
  }
  buf.append(rslt.getXYZ(...));
}
return buf.toString();

Torsten

"Stephen Zeng" <chinafax1@cmmail.com> wrote:
>
>I want to convert a ResultSet Column to string seperated by delimiter such
>as ','
>
>From: (need save ResultSet as list first?)
>a
>b
>c
>
>TO:
>a,b,c

Technical Details

Message-ID: <3aaddef5$1_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!206.252.192.28!news.stealth.net!nntp1.njy.teleglobe.net!teleglobe.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!207.105.83.65

References: <3aaddb92_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,fddce6db9aa2bdb6
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-03-13 01:03:03 PST
From: "Torsten Welches" <torsten.welches@who.cares.netcologne.de>
Sender: "Torsten Welches" <torsten.welches@who.cares.netcologne.de>
Reply-To: "Torsten Welches" <torsten.welches@who.cares.netcologne.de>
Subject: Re: ResultSet Column to string by delimiter such as ','
Newsgroups: borland.public.jbuilder.java.language
X-User-Info: 193.158.55.74 193.158.55.74    
References:  <3aaddb92_1@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3aaddef5$1_2@dnews>
Date: 13 Mar 2001 00:48:53 -0800
X-Trace: 13 Mar 2001 00:48:53 -0800, 207.105.83.65
Lines: 29
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!206.252.192.28!news.stealth.net!nntp1.njy.teleglobe.net!teleglobe.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!207.105.83.65

Reply to Parent Message