2008/5/10 neuro <[EMAIL PROTECTED]>:
> I think this is same as
> http://groups.google.com/group/sqlitejdbc/browse_thread/thread/4b6926a121d07bd8?hl=en
Sorry, but I think you're both wrong. First neuro159, your patch
assumes that SQLite returns <table>.<column>, yet SQLite's behaviour
is unspecified:
'The name of a result column is the value of the "AS"
clause for that column, if there is an AS clause. If there
is no AS clause then the name of the column is
unspecified and may change from one release of SQLite
to the next.' -- http://sqlite.org/c3ref/column_name.html
Though I am still considering your patch, as it will make the driver
more rigorous. However both what you and Máté want to do, namely:
getInt("tablename.colname")
Does not seem to be anything like what the JavaDoc suggests:
"columnLabel - the label for the column specified with
the SQL AS clause. If the SQL AS clause was not
specified, then the label is the name of the column"
-- ResultSet.getInt(String)
I see no reading that would support tablename.colname as "the name of
the column". It seems to me that the real problem here is your select
statements. If there are ambiguities, use the AS construction.
d.
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
