Re: JDBC - access order of fields

2000-08-15 Thread Joe Hanink
ava Server Pages specification and reference [mailto:[EMAIL PROTECTED]]On Behalf Of Flemming Seerup Sent: Tuesday, August 15, 2000 1:50 AM To: [EMAIL PROTECTED] Subject: Re: JDBC - access order of fields hi Neal The "feature" you experience is in fact a well known bug in Suns JDBC-ODBC

Re: JDBC - access order of fields

2000-08-15 Thread Lynch Wu
Hi Neal What about not using "select * from ..." in your SQL statement? Instead use "select column_A, column_X ... from ..."? Besides, columns should not be ordered within a table. That's why a table looks like a hash table rather than an array. Regards Lynch ==

Re: JDBC - access order of fields

2000-08-15 Thread Flemming Seerup
will also gain the features in a JDCB 2.0 driver) /Flemming - Original Message - From: "Neal Cabage" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 15, 2000 7:24 AM Subject: JDBC - access order of fields > When acessing information from my SQLs

JDBC - access order of fields

2000-08-15 Thread Neal Cabage
When acessing information from my SQLserver DB using JDBC, I noticed that I must access the fields sequentially as they're defined in the DB. This is very odd to me. For instance, if the fields are sequentially defined as ID, NAME, and DATE when defining the DB, then later when I attempt to acce