File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes regarding Update syntax of query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "regarding Update syntax of query" Watch "regarding Update syntax of query" New topic

regarding Update syntax of query

smitaj joshi

Joined: Dec 24, 2008
Posts: 3
String sql="update registration set phoneno=" + phone1 + ","+ "emailid=" + emailid1 + " where name="+name1;
ouput of sql-> update registration set phoneno=9860878112, where name=smita

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''.
Dany Mendez

Joined: Nov 04, 2008
Posts: 14
Hello smitaj joshi,

I dont't work with that DBMS, I use oracle, so this is a suggestion.

I can see that you do not limit the strings, could that be the problem?
Like so,
update registration set phoneno=9860878112,emailid='' where name='smita'

I agree. Here's the link:
subject: regarding Update syntax of query
It's not a secret anymore!