sorry out of topic
i am uploading files along with some form data, strategy is i store form data first the primary key is auto_incremented and then i name the uploaded files with the primary key so that i can recognize which uploaded file belongs to who. now when i store the record in mysql i get back a resultset which contains no value (returned by statement.executeQuery(insert ...)). How to get the primary key which is auto generated (incremented by mysql) after inserting a record (primary key of the inserted record). suggestions welcome and thanx in advance # Lalit Nagpal # --------------------------------- Do You Yahoo!? Yahoo! Health - your guide to health and wellness