This week's book giveaway is in the JDBC forum.
We're giving away four copies of Make it so: Java DB Connections & Transactions and have Marcho Behler 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 Make it so: Java DB Connections & Transactions this week in the JDBC 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!