File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Android Security Essentials Live Lessons this week in the Android 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 " = {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
It is sorta covered in the JavaRanch Style Guide.
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