caupena

Good evening
I i'm a beginer user of My SQL, and a have a problem, and i dont`t know how to solve

i compar tree variables with the bd, and if this 3 variables existing in the data base i update the table, and the code are thath under this text
A try a lot of syntax, but all the time my sql says i have a syntax error
Anybody can help me?
Excuse my poor english, i made my best

String query="UPDATE gsdep SET " +
"emp='" + fields.emp.getText() +
"', fil='" + fields.id.getText() +
"', ende='" + fields.dept.getText() +
"', razc='" + fields.first.getText() +
"', ende='" + fields.last.getText() +
"', bair='" + fields.address.getText() +
"', cida='" + fields.city.getText() +
"', esta='" +
fields.state.getText() +
"', cepe='" + fields.zip.getText() +
"', pais='" + fields.country.getText() +
"', email='" +
fields.email.getText() +
"', fone='" + fields.home.getText() +
"', fax='" + fields.fax.getText() +
the problem==> "' WHERE fil= + fields.id.getText()AND emp=fields.emp.getText() AND dept=fields.dept.getText()'";//THE PROBLEM IS IN THIS LINE<<<=====http://www.mysqltalk.com/forums/newthread.php?do=newthread&f=4#

Thanks in advanced
Carlos Pena-Brazil

Administrator

What programming language are you interfacing to mysql with? Your post seems to have gotten messed up towards the end. Can you try to rephrase it?

Or maybe ask the question in your native tongue, maybe someone will be able to translate it? Because we may also have a bit of a language problem too.

caupena

I use Java whit MySQL
The original code are under this line
Thanks in Advanced
Carlos Pena-Brazil

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

public class UpdateRecord implements ActionListener {
private ScrollingPanel fields;
private JTextArea output;
private Connection connection;

public UpdateRecord( Connection c, ScrollingPanel f,
JTextArea o )
{
connection = c;
fields = f;
output = o;
}

public void actionPerformed( ActionEvent e )
{
try {
Statement statement = connection.createStatement();

if ( ! fields.id.getText().equals( "" ) ) {

String query="UPDATE gsdep SET " +
"emp='" + fields.emp.getText() +
"', fil='" + fields.id.getText() +
"', dept='" + fields.dept.getText() +
"', razc='" + fields.first.getText() +
"', ende='" + fields.last.getText() +
"', bair='" + fields.address.getText() +
"', cida='" + fields.city.getText() +
"', esta='" +
fields.state.getText() +
"', cepe='" + fields.zip.getText() +
"', pais='" + fields.country.getText() +
"', email='" +
fields.email.getText() +
"', fone='" + fields.home.getText() +
"', fax='" + fields.fax.getText() +
this Line====>>>> "WHERE emp=fields.emp.getText() AND fil=fields.id.getText() AND dept=fields.dept.getText()" ;<<<====end here
output.append( "\nSending query: " +
connection.nativeSQL( query ) + "\n" );

int result = statement.executeUpdate( query );

if ( result == 1 )
output.append( "\nUpdate successful\n" );
else {
output.append( "\nUpdate failed\n" );
fields.first.setText( "" );
fields.last.setText( "" );
fields.address.setText( "" );
fields.city.setText( "" );
fields.state.setText( "" );
fields.zip.setText( "" );
fields.country.setText( "" );
fields.email.setText( "" );
fields.home.setText( "" );
fields.fax.setText( "" );
}

statement.close();
}
else
output.append( "\nVoce Pode apenas atualizar/alterar\n " +
"um registro existente. Use Pesquisa para \n" +
"localizar o registro e ai \n" +
"modifique a informação e pressione\n " +
"editar para termjinar o processo.\n" );
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
output.append( sqlex.toString() );
}
}
}

HTTPguru

well, did u connect the app with my sql properly

what is the sysntax error and what line does it show.

I prob recommend you to use Access which has an easy interface esp with java or asp.

I donot say that it cannot be done with mysql, but with little heck.