Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

netbeans6.9.1 & mySql CRUD help needed

 
Andrzej Krynski
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic