Syntax error in my UPDATE..please advise

Home Answers Viewqa SQL Syntax error in my UPDATE..please advise

Karen

Syntax error in my UPDATE..please advise
1 Answer(s) a year and 11 months ago
Posted in : SQL

Hi experts,

I tested my code and NetBean IDE gave me the following message:-

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where ID = 2' at line 1 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)

And here's my UPDATE Statement:

String sql = "UPDATE members SET strNRICNO=' " + NRIC
                                + " ', strName=' " + Name + " ', strEmail= ' "
                                + Email + " ', strAddress = ' " + Address + " ',strContact= ' "
                                + Contact + "', strGender = ' " + Gender + "', strRemark =  '"
                                + Remark + "', strAge= '" + Age + "', strQualification= '"
                                + Qualification + "', 
                                + strOccupation ='"
                                + Occupation + "', strSubject= '"
                                + Subject + "', strBudget ='"
                                + Budget + "', where ID = " + selectionId;
                        stmt.executeUpdate(sql);

Please advise how should I change my SQL to use Heidi MySQL.

Tks.

View Answers

July 25, 2011 at 10:56 AM

Here is correct format:

String sql = "UPDATE members SET strNRICNO=' " + NRIC + " ', strName=' " + Name + " ', strEmail= ' " + Email + " ', strAddress = ' " + Address + " ',strContact= ' " + Contact + "', strGender = ' " + Gender + "', strRemark = '" + Remark + "', strAge= '" + Age + "', strQualification= '" + Qualification + "', + strOccupation ='" + Occupation + "', strSubject= '" + Subject + "', strBudget ='" + Budget + "', where ID = " + selectionId+"";
stmt.executeUpdate(sql);

Syntax error in my UPDATE..please advise
Syntax error in my UPDATE..please advise Hi experts, I tested my...; stmt.executeUpdate(sql); Please advise how should I change my SQL to use Heidi MySQL...) And here's my UPDATE Statement: String sql = "UPDATE members SET strNRICNO

Java Syntax - Java Beginners
me why i get an error [List cannot be resolved to a type] when i try to do... my element would be a list? how could i make such a declaration? (p.s.: i... similar on my own...) thank you in advance for any assistance!

sql syntax error help
sql syntax error help this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount...') where is the error ? Please send the error details and the datatype

How to resolve this error The filename, directory name, or volume label syntax is incorrect
How to resolve this error The filename, directory name, or volume label syntax... + createTimeStampStr() + ".PNG"; this my program public class Image... getting this error java.io.FileNotFoundException: http:\www.queen.com

How to Solve the Syntax Error in java??
How to Solve the Syntax Error in java?? Syntax error in java? i have tried this program its showing error like this in Eclipse "Syntax error... of the program "objectname.i" What is the reason for this error??How to access the variable

syntax error in SQL Insert Statement - Java Beginners
syntax error in SQL Insert Statement Dear Sir ,I have write following code to save data into access databse, but code gives following error code... Access Driver] Syntax error in INSERT INTO statement. plz Help Me Hi

syntax error in SQL Insert Statement - Java Beginners
syntax error in SQL Insert Statement private class ButtonListener implements ActionListener{ public void actionPerformed(ActionEvent ae){ //tab1 if(ae.getSource()==bt1ok){ // String date

How to Checking Syntax Error in PHP from Command Line
How to Checking Syntax Error in PHP from Command Line Checking Syntax Error in PHP from Command Line PHP allows you to check your script.... It will check the syntax error in your script and show the â??Unexpected token â

I GOT ERROR FOR MY PROJECT
I GOT ERROR FOR MY PROJECT Dear Friend/ RoseIndia Team, Firstly I would to thank u Guys help me so many time.. I got error on my little project when running at server. please correctly my error Guys... ERROR CODE: "LOGIN

error
error i have 404 error in my program plz tell me yhe solution about

My Sql Error - Development process
My Sql Error Hello Sir ,I have Created Table with following Query,then Table Created Succefully,But some errors Occured, can u give me the Code...,Its Very Very Urgent. Thank u very Much for urs Great Support in My

Syntax of code in HTML5.
The Use of SVG and MathML Syntax of code in HTML5. HTML5 defines an HTML syntax compatible with HTML4 and XHTML1 documents but not compatible.... The documents that use HTML syntax are almost always served with the text/html

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. String sql = "UPDATE emp_details SET empEname = ?, emailId = ?, guid =?, proximityCard =?, managerEmailId = ?, reviewerEmailId

PHP Code Syntax
PHP Code Syntax PHP syntax is the set of rules which need to be followed to to write properly structured PHP code. Given below Some rules of PHP syntax...; <title>My First PHP Page</title> </head> <body> <

error
"+it); } } this is my program i am getting an error saying cannot find symbol class string

error
is"+sum); } } this is my program i need to print the series (1+2/12)+(1+2

how do i update my database with the help of update syntax in html <text/javascript>? How to write 'where' statement in this?
how do i update my database with the help of update syntax in html ? How to write 'where' statement in this? var sqlmek="update into Student_info...'); alert('Press OK to Update your Records Successfully

i am unable to identify the error in my code
i am unable to identify the error in my code class Program { public static void main(String[] args) { BufferedReader br=new BufferedReader(new InputStreamReader(System.in)); System.out.println("enter

my answer
my answer import com.mysql.jdbc.Connection; import...-specific error occurs * @throws IOException if an I/O error occurs */ protected... ServletException if a servlet-specific error occurs * @throws IOException if an I/O

ERROR with my JAVA code - Java Beginners
ERROR with my JAVA code The error came up in my main method... it wasnt there until i finished my actionListener coding so I dont know how to fix this....it is really stressing me out!! HELP!!! import java.awt.*; import

What's wrong with my pagination code in JSP?
What's wrong with my pagination code in JSP? Dear experts, I've... whatever lines that NetBean IDE has given me error signal. The resulted page.... Hope someone can advise me how to. Thanks! print("code sample"); <

XML Syntax Rules
XML Syntax Rules ... to create his own tags. Note - XML documents use a self-describing and simple syntax... is quite self-descriptive? Now let's discuss its syntax-rules which are very simple

my question is related to my project viz
my question is related to my project viz Sir, my project is based on MR tracking system developed using struts framework, it has been developed... the browser is showing "No Such Class Found Error" im unable to sort out the error

Further advice needed on my last question - JSP-Servlet
Further advice needed on my last question Dear Experts, I refer to your last solution regarding my matching codes. After I tried out your... errors Here are my codes which I modified but basically followed your logic

SET Syntax
_packet=2; ERROR 1382 (HY000): The 'SET ONE_SHOT' syntax is reserved for purposes...; ERROR 1175 (HY000): You are using safe update mode and you tried to update a table... SET Syntax

Still getting the http 404 error - Java Beginners
that the login is part of my index page where I have other things in that page. So, please advise if it is ok to put a login at the right hand column of that page. 2... = ? AND password = ?"; Can I know why you have put username whereby my name in the form

plz check my codings are correct or not...There is an error..i cant find it..
plz check my codings are correct or not...There is an error..i cant find it.. import java.util.Scanner; public class Student { private String indexNo; private String gender; private char initial; private int mark1

Need help with my project
Need help with my project Uses a while loop to perform the following steps: -Prompt the user to input two integers: firstNum and secondNum where... numbers, and if not, provide error feedback and prompt them again. -Output all

404 error
404 error struts application having 404 error while hosting to a online server.it works fine in my local machine but dont work in virtual host.showing 404 error

error in driver
error in driver i have done connection settings for oraclethin driver in netbeans ide 6.9.1. and i was able to view tables of my database.but when i am trying to access tables from my java class i was getting error

404 error
404 error hello anybody help me when i deployed my ear file into jboss->server-> default->deploy folder it doesn't shows any error. but when i run this application by using localhost:8080/webapp ,it shows 404 error

404 error
404 error i have 404 error in my addition programe of servlet how should i solve this. i'm using netbean on glassfish server

error log
error log hi my requirement is validate xml and xsd in java.If there is an errors then i will log error and store into error table. so plz if any one knows send code urgent. error table details-------------- Table

installation error
installation error Error : Invalid path, "C:\Program Files\Java\jdk1.6.0\bin\javac.exe" -g -classpath "C:\Documents and Settings\Admin\My Documents" -d "C:\Documents and Settings\Admin\My Documents" "C:\Documents and Settings

to add on to my queries - Java Beginners
to add on to my queries Dear Experts, Sorry but I am worried that I did not explain clearly so I am adding in the error message I get from... in that codes. Many thanks. An error occurred: java.sql.SQLException

Please Help To Solve My Problem
Please Help To Solve My Problem PHP I Have 6 Textbox and 1 ok... Play Second Match With Same Team Then Generate The Error... EXAMPLE: A Team Play With B Team when A Team Play With B Team Again Then Generate Error. I Am Solve

Problem in my code - Development process
Problem in my code Plz go thru this code. I want to check login and pwd with database. Backend MsAccess , Table name : Reg , Dsn Name: JJ While executing code am getting 404 error User Name Password

Error in servlets
Error in servlets I cant execute my servlet or jsp programs. Im getting an error resource not found. I am using tomcat 6.0. I have set the path and class path correctly. My code is also correct. I have done everything but i

Error in JfreeChart
Error in JfreeChart I am getting an error when i am using jfreechart for graph generation, that is: D:\my\linechart.java:5: package org.jfree.chart... solution to the problem. Hello Friend, Please visit the following link

pls review my code - Struts
pls review my code Hello friends, This is the code in struts. when..."); // System.out.println("PLEASE FILL THE FIELDS"); else try...("error in connecting database"); } return null

Help Me in My Java Work
Help Me in My Java Work Can you help me please... Write a Java application, to be called GpaCalculator, which will return a grade point average... appropriately to invalid input (by displaying an error message if the user enters a number

syntax for create a table
syntax for create a table syntax for create a table

http 404 resource not found error
not found error. Kindly advise. ss...http 404 resource not found error Sir, I have downloaded your RichLRApplication and deployed on tomcat 6 with oracle backend. Application started

output error
output error this is my program import java.io.*; public class...]; for (k=0;k } } if i enter "my name" as the input the output is only "my" what is the error.my actual out put should be"my name

Latest
Frameworks
Category