wood burning stoves 2.0*
The moose likes JavaFX and the fly likes netbeans6.9.1 & mySql CRUD help needed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JavaFX
Bookmark "netbeans6.9.1 & mySql CRUD help needed" Watch "netbeans6.9.1 & mySql CRUD help needed" New topic

netbeans6.9.1 & mySql CRUD help needed

Andrzej Krynski

Joined: Oct 04, 2010
Posts: 3
could you help me with this?:
I have folowing label in Grid Form

To delete actual record from db I added a button which performs following action:

But it returns error massage: Unknown column 'here_value_from_{nameValueLabel.text}' in 'where clause'
Value from {nameValueLabel.text} is right column value.
Database has simple structure:
table: client-
id - primary key
name - column
subdomain - index
table: another ... ect.

In where clause I tried "client.name = {nameValueLabel.text}" and "name = {nameValueLabel.text}" and neither works.

Question is what am I doing wrong and how to perform Copy, Retrieve, Update, Delete actions correctly?

Best regards, Andrzej Kryński

Lately I tried with:

but with no success too
This code changes datasource I think ( on screen data are removed) but doesn't act on database physically.

Andrzej Kryński
Don't get me started about those stupid light bulbs.
subject: netbeans6.9.1 & mySql CRUD help needed
Similar Threads
Delete Query in hibernate doesnt work
How to delete the row from the Database by using while loop in servlet
Getting Problem in Delete operation in Struts application
Hql delete syntax?
delete query in hibernate giving error as null, and not deleting the record