aspose file tools
The moose likes JavaFX and the fly likes netbeans6.9.1 & mySql CRUD help needed Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JavaFX
Reply Bookmark "netbeans6.9.1 & mySql CRUD help needed" Watch "netbeans6.9.1 & mySql CRUD help needed" New topic
Author

netbeans6.9.1 & mySql CRUD help needed

Andrzej Krynski
Greenhorn

Joined: Oct 04, 2010
Posts: 3
Hi,
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

p.s.
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: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: netbeans6.9.1 & mySql CRUD help needed
 
Similar Threads
Delete Query in hibernate doesnt work
Getting Problem in Delete operation in Struts application
Hql delete syntax?
delete query in hibernate giving error as null, and not deleting the record
How to delete the row from the Database by using while loop in servlet