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

Reply via email to