Re: MySQL and Java : Column not found

z0man wrote: 
I have a database called dbuild and a table called news

with sample entries added by the DB_News.java So I have managed to communicate to the MySQL database and do stuff.

Here is my new problem when I try and get "article" which is a "TEXT" data format. It says the column is there. BUT IT IS!!!

  news_id = getnews_id();
  dbhandler.newSession();
  String sql = "select * from news where id = '"+news_id+"'";
  rs = dbhandler.doQuery(sql);
  headingTextField.setText(rs.getString("heading"));<-- This works
  contentTextArea.setText(rs.getString("article")); <-- This does work
  dbhandler.closeSession();

Any help much apperciated

z0man

I think it could be because the TEXT format does not work with rs.getString(String colname); I have tried using rs.getString(int col) and that dont work either. Any suggestions?

I decided to post this to mysql.com forum as I really stumped.

z0man
.

Relevant Pages

  • Re: MySQL and Java : Column not found
    ... z0man wrote: ... with sample entries added by the DB_News.java So I have managed to communicate to the MySQL database and do stuff. ... data format. ...
    (comp.lang.java.databases)
  • Re: MySQL and Java : Column not found
    ... z0man wrote: ... with sample entries added by the DB_News.java So I have managed to communicate to the MySQL database and do stuff. ... data format. ...
    (comp.lang.java.databases)
  • MySQL and Java : Column not found
    ... with sample entries added by the DB_News.java So I have managed to communicate to the MySQL database and do stuff. ... data format. ...
    (comp.lang.java.databases)