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
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
I agree. Here's the link:
subject: netbeans6.9.1 & mySql CRUD help needed
jQuery in Action, 3rd edition