Re: MySQL and Java : Column not found

IchBin wrote:

z0man 
What does you database table definition look like? Just in case..

Here is a better view of the table
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| n_id    | mediumint(9) |      | PRI | NULL    | auto_increment |
| heading | varchar(255) |      |     |         |                |
| article | text         |      | MUL |         |                |
+---------+--------------+------+-----+---------+----------------+

I saw somone trying to enumarate the SELECT instead of using the * for example,

mysql> select `heading`,`article` from news where n_id = 4;
+----------------+-------------------+
| heading        | article           |
+----------------+-------------------+
| Test Heading 3 | My first document |
+----------------+-------------------+

I compiled it Java and saddly no it didn't work

z0man
.