It's a problem that some JDBC/ODBC drivers have -- you
have to live with it, simply pull all the values from
the ResultSet after the select.
anyway
WHAT THE HELL THESE *!#$@& DB-RELATED QUESTIONS HAVE
TO SHARE ON A JSP (I repeat it: JSP!) MAILING LIST?
(Joseph Ottinger, where are you :-) ?
Senior Software Engineer
Andrea Vicentini
www.abaXX.de
----- Original Message -----
From: "sandarbh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 3:20 PM
Subject: Re: Sequence Problem
> if we use column index it does not give a problem
but then same should apply
> for field index. why not??
>
> sandarbh
> ----- Original Message -----
> From: "Peter Pilgrim" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, February 21, 2001 2:03 PM
> Subject: Re: Sequence Problem
>
>
> > Why don't you use the column index
> >
> > rst.getString(1);
> > rst.getString(2);
> > rst.getString(3);
> >
> > then it doesn't matter how you permutate ....
> >
> > rst.getString(3);
> > rst.getString(1);
> > rst.getString(2);
> >
> > --
> > Peter Pilgrim
> > G.O.A.T
> > "the Greatest Of All Time"
> >
> >
> >
> > ---------------------------------------- Message
> History ----------------------------------------
> >
> >
> > From: Muhammad Asim Ajmal
<[EMAIL PROTECTED]>@java.sun.com> on
> 21/02/2001 17:33 ZE5
> > --<CUT>--
> >
> > hi!!!!
> >
> > i want to know some thing about sequence problem
for getting result from a
> > query,
> >
> > e.g. select a, b, c, from table;
> >
> > then !!
> > rst.getString("a");
> > rst.getString("b");
> > rst.getString("c");
> >
> > well this works fine,, but if i change the
sequence like
> >
> > rst.getString("b");
> > rst.getString("a");
> > rst.getString("c");
> >
> > this create the problem,,, i wanna over come this
problem,,, has API3 of
> > JDBC can
> > give the solution???
> >
> > currnetly i m using SQL Server database and JDBC
type 2 drivers...
> >
> >
> >
> >
> > --
> >
> > This e-mail may contain confidential and/or
privileged information. If you
> are not the intended recipient (or have received
this e-mail in error)
> please notify the sender immediately and destroy
this e-mail. Any
> unauthorised copying, disclosure or distribution of
the material in this
> e-mail is strictly forbidden.
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with
body: "signoff
> JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with
body: "set JSP-INTEREST
> DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found
at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> >
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with
body: "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body:
"set JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets