try this:
int rowsAffected = stmt.executeUpdate("delete from member where member_id
='" +member_id+"'");

bye!
:)

Andrea Manca
Nacon s.r.l
via Cesarea 2/45
16121 Genova (GE)
tel:010/583158
e-mail:andrea.manca@n...
web:http://www.nacon.it



-----Original Message-----
From: Super Powerfulrez [mailto:powerfulrez@g...]
Sent: giovedì 29 marzo 2001 20.37
To: Pro_JavaServer_Pages
Subject: [pro_jsp] query problem


i got a problem here
this is my query

int rowsAffected = stmt.executeUpdate("delete from member where member_id
='" +member_id);

but i get this error

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax
error in string in query expression 'member_id ='something'.

my member_id is string of 15 characters
where did i go wrong?

benjamin

___________________________________________________
GO.com Mail
Get Your Free, Private E-mail at http://mail.go.com