This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
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 Elasticsearch in Action this week in the Big Data 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'

Consider Paul's rocket mass heater.
subject: regarding Update syntax of query