Java Answers Forum

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Answers Forum
Help!!!!

3 replies on 1 page. Most recent reply: Mar 27, 2002 3:09 PM by Elliott Wood

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 3 replies on 1 page

Elliott Wood

Posts: 15
Nickname: tooess
Registered: Mar, 2002

Help!!!!

Posted: Mar 26, 2002 2:07 PM

I'm trying to write a method that deletes a record from a ms access table but no matter what I do it won't delete. other queries and methods work fine .

The method is

public void deleteFromBook(String anISBN)throws SQLException
{
query = "DELETE * FROM book WHERE isbn ='" + anISBN+"'";
statement.executeUpdate(query);
}

Any ideas would be greatly appreciated thanks.

Mohit Gupta

Posts: 15
Nickname: mohit
Registered: Mar, 2002

Re: Help!!!!

Posted: Mar 26, 2002 4:04 PM

try this ::

query = "DELETE book WHERE isbn ='" + anISBN+"'";

abhijeet

Posts: 13
Nickname: aaraje
Registered: Mar, 2002

Re: Help!!!!

Posted: Mar 26, 2002 8:51 PM

Query may be wrong
delete * from is invalid query
instead you write delte from book where isbn="+ansiban+""

Elliott Wood

Posts: 15
Nickname: tooess
Registered: Mar, 2002

Re: Help!!!!

Posted: Mar 27, 2002 3:09 PM

Thanks for the reply, I gave what you sugested a try but it didn't work, however I did get it to work by doing the following

public void deleteFromBook(String anISBN)throws SQLException
{
if(canDeleteBook(anISBN))
{
query = "DELETE * FROM book WHERE isbn ='" + anISBN+"'";
statement.executeUpdate(query);
statement.executeUpdate(query);
}
}

I don't know why this works but it does, do you have any ideas?

Flat View: This topic has 3 replies on 1 page

Previous Topic

Next Topic


	Web Artima.com