Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Accessing Result set with column names

2 posts in JConnect version 3.0 Last posting was on 2001-03-13 13:08:51.0Z
Anonymous Posted on 2000-08-23 16:02:52.0Z
From: Anonymous@sybase.com
Date: Wed, 23 Aug 2000 12:02:52 -0400
Newsgroups: sybase.public.jconnect30
Subject: Accessing Result set with column names
Message-ID: <763BE8EA959A33030058273D85256944.0058274B85256944@webforums>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.jconnect30:209
Article PK: 256628

I have a problem accessing the result set with column names. Since I know
the column names returned by the SQL Query, I want to access the result set
with the column names (rather than the column position). Doing this with
jconnect is not working. Am I missing anything here. Please help if
anyone knows how to do this.


lance.andersen Posted on 2001-03-13 13:08:51.0Z
From: lance.andersen@sun.com
Date: Tue, 13 Mar 2001 08:08:51 -0500
Newsgroups: sybase.public.jconnect30
Subject: Re: Accessing Result set with column names
Message-ID: <472A8679056FE1A9004838A885256A0E.004678D485256945@webforums>
References: <763BE8EA959A33030058273D85256944.0058274B85256944@webforums>
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.jconnect30:189
Article PK: 254557

Accessing columns by names works fine. Make sure you spell
the column name correctly and with the correct case.