Hi
Yes, I have the same problem indeed if I repeat a field , like
a=rst.getString("a"); // Here all works fine.
b=rst.getString("a"); // Oppps, this causes an error.
I don´t know if this problem is caused by Jdbc, or by Sql Server and if it
happens with other databases.
The only one solution to read the fields in other order that I know is
introduce the values of the fields in an array, and to look at the array
after.
Regards
David Mellado
[EMAIL PROTECTED]
-----Mensaje original-----
De: Muhammad Asim Ajmal <[EMAIL PROTECTED]>
Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Fecha: miércoles, 21 de febrero de 2001 13:38
Asunto: Sequence Problem
>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...
>
>waiting for reply
>
>---------------------------------------------------
>ASIM
>VisualSoft Development (Pvt) Ltd.
>#301, Peshawar Road,
>Rawalpindi Cantt 46000,
>Pakistan.
>www.visualsoft-inc.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
===========================================================================
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
