Re: MySQL and Java : Column not found

From: z0man <z0manifest@xxxxxxxxx>
Date: Sun, 29 Jan 2006 19:17:39 GMT

Sorry I meant to say:

It says "the 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

Follow-Ups:
- Re: MySQL and Java : Column not found
  - From: IchBin

References:
- MySQL and Java : Column not found
  - From: z0man

Prev by Date: MySQL and Java : Column not found
Next by Date: Re: java long in an Access database
Previous by thread: MySQL and Java : Column not found
Next by thread: Re: MySQL and Java : Column not found
Index(es):
- Date
- Thread

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)