Meaningless Drivel is fun!*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » JavaFX
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://aspose.com/file-tools
 
subject: netbeans6.9.1 & mySql CRUD help needed