MySQL and Java : Column not found
- From: z0man <z0manifest@xxxxxxxxx>
- Date: Sun, 29 Jan 2006 18:52:47 GMT
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: z0man
- Re: MySQL and Java : Column not found
- From: z0man
- Re: MySQL and Java : Column not found
- Prev by Date: Re: row read performance
- Next by Date: Re: MySQL and Java : Column not found
- Previous by thread: need Oracle jdbc connection example source code
- Next by thread: Re: MySQL and Java : Column not found
- Index(es):
Relevant Pages
|
|
