Hello Ranchers!! I'm new to java ranch!! here i'm doing some database project in jsp and oracle!! i'm planning to do some administrative privilage ie., only the administrator can edit or delete some datas in the database.. the edit is successful.. but the delete is making me problems..
i've created a jsp page.. in that page.. there is a table... the first column.. is a check box.. the second column is the record from database and so on up to 10th column.. _____________________________________________________________________ | check |col1 | col2 |col3 | col4 | |--------------------------------------------------------------------- | | | | | | | | | | | | | | | | | | |____________________________________________________________________
so.. the datas are displaying like this in the jsp page.. if i want to delete the first and the 5th record.. i check the check box corresponding to that!!
int the check box name.. i'm giving the value for search query!! like file number!! and it is passing to another jsp page when i press submit...and deletion takes place.. how can i do that!!
please help ranchers..
if u got the idea..and if u have the code please send me!! thanks in advance!! regards megha
Hello Megha.. i'm also looking for the same doubt... if we can get the row id.. then we can particularly delete the row with that row id na
but i don't think it is possible.. y can't u got for a primary key in the table.. i think that may be easier for deleting!! know!!
Joined: Mar 22, 2006
Hello Aravind!! But when i created the table i left to give the primary key.. and now abt 100 records are there.. so... if i want to delete one there is duplication orruring.. thatz why.. i need to get the row id..
can any one in the ranchers please help me.. how to get the row id from oracle table
i can execute the query.. select rowid from the table but i cannot the the values.. from that for that what should i do!! i think it is a string value.. we cannot also use.. Result set.. since that is not in the table.. so if u know please help me!!